By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

How to get System Date in DB2 with SQL Statements

P: 2
How to get System Date in DB2 with SQL Statements
Aug 3 '07 #1
Share this Question
Share on Google+
1 Reply


P: 57
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.