Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to get current date by spufi?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
luban

New User


Joined: 19 Nov 2005
Posts: 26
Location: Shanghai, China

PostPosted: Fri Dec 12, 2008 7:03 pm    Post subject: How to get current date by spufi?
Reply with quote

Hi,

Can any person tell me how to get current date by spufi?

Thank you.

Ban
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Dec 12, 2008 7:13 pm    Post subject:
Reply with quote

Hi LUBAN,

This can help you
Code:
SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1; 


Sushanth
Back to top
View user's profile Send private message
luban

New User


Joined: 19 Nov 2005
Posts: 26
Location: Shanghai, China

PostPosted: Fri Dec 12, 2008 8:22 pm    Post subject:
Reply with quote

Hi Sushanth,

Actually, I need to run a job every day, to get data of previous day.
So the spufi will be like:

SELECT MY_DATA FROM MY_TABLE
WHERE
MY_DATA = previous date (YYYYMMDD);

How can I get previous date ( I think current - 1 ) in form YYYYMMDD?

Anyone can help?

Thank you.

Ban
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 12, 2008 10:23 pm    Post subject:
Reply with quote

Hello,

Are weekends and holidays the handled same as "regular" days or is there some consideration for these that is not the same?
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Dec 15, 2008 10:44 am    Post subject:
Reply with quote

Luban,

If you want just the previous day date, you can use this query.
Code:
SELECT  ( CURRENT DATE - 1 DAY ) AS YESTERDAY
      , ( CURRENT DATE ) AS TODAY             
  FROM  SYSIBM.SYSDUMMY1                     
;                                             


Code:
previous date (YYYYMMDD);


Since you put it in this way, are you looking for BUSINESS previous day. If that so, you must write a function or procedure to get that, taking into consideration with things like festival holiday, bank holiday, country holiday and more holidays like that. You are looking for an year calender.

Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
This topic is locked: you cannot edit posts or make replies. Get correct date and time when curren... balaji81_k DB2 24 Fri Oct 14, 2016 10:40 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts Add system date inside of a PS file a... pramitdas DFSORT/ICETOOL 5 Sun Aug 28, 2016 12:06 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us