Table of ContentsPreviousNext

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.

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
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.