Current time and timestamp

iskander · #1 (**permalink**) 11-12-07, 11:21

what is the difference between CURRENT TIME and CURRENT TIMESTAMP ?

stolze · #2 (**permalink**) 11-12-07, 11:24

Time is just that: hours, minutes, seconds and fractions of seconds. A timestamp includes date information.

iskander · #3 (**permalink**) 11-12-07, 12:05

Thanks!
I couldn't find that in the manual

Marcus_A · #4 (**permalink**) 11-12-07, 19:10

Quote:

Originally Posted by iskander

Thanks!
I couldn't find that in the manual

DATE, TIME, and TIMESTAMP are DB2 column types, and they are documented in the manual.

stolze · #5 (**permalink**) 11-13-07, 02:07

5th hit when searching for all 3 names in the manual:

http://publib.boulder.ibm.com/infoce...c/r0008474.htm

grofaty · #6 (**permalink**) 11-13-07, 03:15

iskander,
the easiest way is to try thinks out:

Code:

select current timestamp, current time, current date from sysibm.sysdummy1

Hope this helps,
Grofaty