The following table lists limitations on date, time, and timestamp values in . 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-24.00.00.000000