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