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, TIME and TIMESTAMP

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

DATE

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.

TIME

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.

TIMESTAMP

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).