467,923 Members | 1,857 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

How to get System Date in DB2 with SQL Statements

How to get System Date in DB2 with SQL Statements
Aug 3 '07 #1
  • viewed: 57896
Share:
1 Reply
The CURRENT DATE special register gives the current system date and CURRENT TIMESTAMP the current system date and time. This can be used in select statements or more directly using the VALUES statement:

Expand|Select|Wrap|Line Numbers
  1. values current date;
  2.  
  3. values current timestamp;
  4.  
  5. select current date from sysibm.sysdummy1;
Aug 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by The Spoon | last post: by
11 posts views Thread by Mike9900 | last post: by
3 posts views Thread by Tull Clancey | last post: by
2 posts views Thread by Srikanth Ram | last post: by
4 posts views Thread by anagai | last post: by
1 post views Thread by nbharatha | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.