The following table lists limitations on date, time, and timestamp values in . limitationsDATE, TIME, and TIMESTAMP values DATE valueslimitations TIME valueslimitations TIMESTAMP valueslimitations

This table lists the limitations on date, time, and timestamp values. Value Limit Smallest DATE value 0001-01-01 Largest DATE value 9999-12-31 Smallest TIME value 00:00:00 Largest TIME value 24:00:00 Smallest TIMESTAMP value 0001-01-01-00.00.00.000000 Largest TIMESTAMP value 9999-12-31-23.59.59.999999