364,036 Members | 5451 Browsing Online
Community for Developers & IT Professionals
Bytes IT Community
Post New Question »
Latest Articles Questions FAQ
home > db2 database > db2 database questions

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

Question stats

  • viewed: 33763
  • replies: 1
  • date asked: Aug 3 '07

Most Active

  1. docdiesel230
  2. sakumar9125
  3. r035198x118
  4. vijay208291
  5. cburnett56

Most Questions Answered

  1. vijay20823
  2. Alan Simpson1
  3. Venkat G1
  4. kleach1
  5. hitendrap1

Top Questions

  1. Getting DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002 exception34317
  2. How to get System Date in DB2 with SQL Statements33321
  3. How to determine the DB2 version24899
  4. Protocol specific error code(s): "10060", "*", "*". SQLSTATE=0800122582
  5. Db2 Union21837

Latest Questions

  1. connect asp.net and db2108
  2. sql 1390c error while installing DB2 8.1 on windows 7121
  3. REPLACE in packages vs plans133
  4. DB2 Error: "MODIFIES SQL DATA" clause has not been specified107
  5. How to get out of "BACKUP PENDING. SQLSTATE=57019 on DB2" State250

Similar topics

More

BYTES.COM © 2012
Formerly "TheScripts.com" from 2005-2008
About Bytes | Advertise on Bytes
Sitemap | DB2 Database Answers Sitemap | DB2 Database Insights Sitemap

Follow us to get the Latest Bytes Updates