364,036 Members | 5451 Browsing Online
Community for Developers & IT Professionals
Bytes IT Community

How to get System Date in DB2 with SQL Statements

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


cburnett
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

Help answer this question



Didn't find the answer to your DB2 Database question?

You can also browse similar questions: DB2 Database