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 How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts SUBSTR for Date functions Shaheen Shaik DB2 4 Thu Apr 06, 2017 2:14 pm


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