Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
Mahua Mitra

New User

Joined: 26 Apr 2007
Posts: 49
Location: Delhi

 Posted: Wed Mar 26, 2008 12:14 pm    Post subject: Gregorian date formats Hi What is the gregorian Date format : YYMMDD or CCYYMMDD ? Say if I wish to use the function INTEGER-OF-DATE Thanks

Mahua Mitra

New User

Joined: 26 Apr 2007
Posts: 49
Location: Delhi

 Posted: Wed Mar 26, 2008 12:51 pm    Post subject: Let me complete the query: Say If I wish to use the function INTEGER-OF-DATE, which amongst the two should be provided as input. Thanks
enrico-sorichetti

Global Moderator

Joined: 14 Mar 2007
Posts: 10396
Location: italy

Posted: Wed Mar 26, 2008 12:56 pm    Post subject: Reply to: Gregorian date formats

 Quote: .... If I wish to use the function INTEGER-OF-DATE, which amongst the two should be provided as input.

Wouldn' t it be faster to search the doc rather than wait for a forum answer
( or search the forum ) ??

a good old plaint stupid google search pointed back to a forum post with all the details
Anuj Dhawan

Senior Member

Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

 Posted: Wed Mar 26, 2008 12:59 pm    Post subject: Hi, Use YYYYMMDD.
Anuj Dhawan

Senior Member

Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

Posted: Wed Mar 26, 2008 1:04 pm    Post subject:

Hi,

Ah..little more..

FUNCTION INTEGER-OF-DATE--(argument-1)

argument-1: Must be an integer of the form YYYYMMDD, whose value is obtained from the calculation (YYYY * 10,000) + (MM * 100) + DD.

- YYYY represents the year in the Gregorian calendar. It must be an integer greater than 1600, but not greater than 9999.
- MM represents a month and must be a positive integer less than 13.
- DD represents a day and must be a positive integer less than 32, provided that it is valid for the specified month and year combination.

P.S.: Well, would like to repeat enrico...
 Quote: it be faster to search the doc
Trust me that's rather fast..
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm Comparing dates in different formats migusd SYNCSORT 4 Sat Nov 18, 2017 3:02 am Date in where clause - Windows Karthikeyan Subbarayan DB2 9 Wed Nov 15, 2017 9:07 pm Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm Validate the Date girishb2 DFSORT/ICETOOL 9 Tue Sep 19, 2017 1:12 am

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us