Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DATE computation in DB2

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

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Fri Sep 16, 2005 2:57 pm    Post subject: DATE computation in DB2
Reply with quote

While checking validity of dates,is there any method other than checking for date,month and year separately? Are there any special functions using which we can compare a given date directly with SYSTEM date?
Back to top
View user's profile Send private message

vcsreddy

New User


Joined: 25 Jun 2005
Posts: 5

PostPosted: Wed Oct 05, 2005 5:38 pm    Post subject:
Reply with quote

comparision on what.can u give me brief explanation of u r query
Back to top
View user's profile Send private message
iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Thu Oct 06, 2005 7:08 am    Post subject: date computation
Reply with quote

Hi

How to compare system date with the date supplied by the user. Is there any special functions to achieve it.
Back to top
View user's profile Send private message
krishnaiahc

New User


Joined: 31 Aug 2005
Posts: 21

PostPosted: Fri Oct 28, 2005 6:24 am    Post subject:
Reply with quote

Hai,

The system date will come in the form of "yyyy-mm-dd" and user suplied date have to convert to standard date format "yyyy-mm-dd" .

Now you compare the both dates . Let me know if any concerns.


Thank,
Krishna
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Mon Oct 31, 2005 12:33 pm    Post subject: date comparision
Reply with quote

hi,
use currentdate command to extract the system date and just compare with the user date. c that the user date should match with the system date format 'yyyy-mm-dd'


correct me if i m wrong
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 Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm
No new posts Validate the Date girishb2 DFSORT/ICETOOL 9 Tue Sep 19, 2017 1:12 am
No new posts Julian Date to CICS ABSTTIME blayek CICS 3 Wed Aug 30, 2017 11:15 pm
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

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us