NexusDB V3 Manual
DateTime Types
|
|
NexusDB Manual V3 > SQL Reference > SQL Data Types
|
Syntax
<datetime type> ::=
|
|
|
|
|
|
DATE
TIME
TIMESTAMP
DATETIME
|
Notes
§
|
DATE is a 4 byte type that contains the datetime fields YEAR, MONTH and DAY.
|
§
|
TIME is a 4 byte type that contains the datetime fields HOUR, MINUTE and SECOND.
|
§
|
TIMESTAMP is a 8 byte type that contains the datetime fields YEAR, MONTH, DAY, HOUR, MINUTE and SECOND.
|
§
|
DATETIME is a NexusDB synonym for TIMESTAMP.
|
§
|
The time precision of the datetime types is milliseconds, 3 digits following the decimal point in the SECOND datetime field.
|
§
|
Two date time values are comparable only if both have the same datetime fields.
|
§
|
A datetime value is assignable only to a datetime site having the same datetime fields.
|
Conformance
SQL:2003 standard
NexusDB extensions
|
-
-
|
Core SQL
DATETIME
|
|
© Nexus Database Systems Pty Ltd.