Chapter 6 SQL Language Elements
247
Special values
Special values can be used in expressions, and as column defaults when
creating tables.
CURRENT DATE special value
CURRENT DATE returns the current year, month, and day.
DATE
"Expressions" on page 230
"TIME data type" on page 282
CURRENT TIME special value
The current hour, minute, second and fraction of a second.
TIME.
The fraction of a second is stored to 6 decimal places. The accuracy of the
current time is limited by the accuracy of the system clock.
"Expressions" on page 230
"TIME data type" on page 282
CURRENT TIMESTAMP special value
Combines CURRENT DATE and CURRENT TIME to form a
TIMESTAMP value containing the year, month, day, hour, minute, second
and fraction of a second. Like CURRENT TIME, the system clock limits the
accuracy to a fraction of a second.
The fraction of a second is stored to 3 decimal places. The accuracy is
limited by the accuracy of the system clock.
TIMESTAMP
"Expressions" on page 230
"TIMESTAMP data type" on page 283
Function
Data type
See also
Function
Data type
Description
See also
Function
Data type
See also
To Next Page
Loading...