![]() Previous |
![]() Next |
The TIMESTAMP
data type is an extension of the DATETIME
data type. It stores the year, month, and day of the DATETIME
data type, plus hour, minute, and second values. This data type is useful for storing precise time values.
SHOW SYSDATE 26-JUL-06 DEFINE mytimestamp VARIABLE TIMESTAMP mytimestamp = SYSDATE COLWIDTH = 30 REPORT mytimestamp MYTIMESTAMP ------------------------------ 26-JUL-06 10.44.42 AM
The TIMESTAMP
data type stores year, month, day, hour, minute, and second, and fractional second values. When you specify TIMESTAMP
as a literal, the fractional seconds precision value can be any number of digits up to 9, as follows:
TIMESTAMP '1997-01-31 09:26:50.124'