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

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Data Types