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