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

Query to fetch the current Date from db2.
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Knowledge Hunter

New User


Joined: 17 Aug 2006
Posts: 22
Location: India
PostPosted: Thu Mar 15, 2007 3:29 pm
 Reply with quote
hi,

i need a query to fetch the current Date from db2.

Can you throw me some light on it, since i am new to db2.

Thanks,
Yogesh
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
PostPosted: Thu Mar 15, 2007 4:07 pm
 Reply with quote
Hi There,

Code:
SELECT CURRENT_DATE   
FROM SYSIBM.SYSDUMMY1;
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark
PostPosted: Thu Mar 15, 2007 6:12 pm
 Reply with quote
Or,

SELECT CURRENT DATE AS DATE FROM SYSIBM.SYSDUMMY1


DATE
----------
2007-03-15


** END ***
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 To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
No new posts Need to convert date format DFSORT/ICETOOL 20
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us