IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DATE computation in DB2


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
iknow

Active User


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

PostPosted: Fri Sep 16, 2005 2:57 pm
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
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: 411
Location: Colarado, US

PostPosted: Thu Oct 06, 2005 7:08 am
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
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: 677
Location: NJ

PostPosted: Mon Oct 31, 2005 12:33 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Need help to append a date&tsp at... DFSORT/ICETOOL 9
No new posts Fetch data from programs execute (dat... DB2 3
Search our Forums:

Back to Top