Table of ContentsPreviousNext

Ispirer             Ispirer

Ispirer SQLWays Database Migration Software


Date and time data types for representing date and time of day.


The DATE data type stores date information (year, month, day) from 01-01-0001 through December 31, 9999. The DATE data type is stored internally as a 4-byte value.


The TIME data type stores time information (hour, minute, second and hundreds of a seconds) from 00:00:00 through 23:59:59.

The TIME data type is stored internally as a 4-byte value.


The TIMESTAMP data type stores day and time information (year, month, day, hour, minute, second and fractional seconds) from 0001-01-01 00:00:00.0000000 through 9999-12-31 23:59:59.9999999 UTC.

The TIMESTAMP data type is stored internally as a 8-byte unsigned value representing septaseconds (10^-7 second) since January 1, 0001 in a Gregorian calendar, Coordinated Universal Time (UTC).

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.