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 Database Conversion overview.

Ispirer SQLWays Database Migration Software

DATE, TIME and TIMESTAMP

DATE

The DATE data type stores the date information (year, month, day). The supported range is January 1, 0001 to December 31, 9999.

TIME

The TIME data type stores the time information (hours, minutes, seconds). The supported range is 00 hours 00 minutes 00 seconds to 24 hours 00 minutes 00 seconds.

If the hour is 24, the minute and second specifications are zero.

TIMESTAMP

The TIMESTAMP data type stores the date and time information (year, month, day, hour, minute, second, and microsecond). The supported range is January 1, 0001 00 hours 00 minutes 00 seconds 000000 microseconds to December 31, 9999 24 hours 00 minutes 00 seconds 000000 microseconds.