DateTime Types

Wed, 03/04/2009 - 20:02 |  hdanzl


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
‹ Boolean TypesupValue Expressions ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Data Types

Powered by Drupal and Drupal Theme created with Artisteer.