Date and Time Sizes, Formats, and Ranges : Date Type « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. Date Type

Date and Time Sizes, Formats, and Ranges

     

Type           Bytes    Format                  Start Date                                  End Date
 
DATE           3        YYYY-MM-DD              1000-01-01                                  9999-12-31
 
DATETIME 
and TIMESTAMP  8        YYYY-MM-DD HH:MM:SS     1000-01-0100:00:00                          9999-12-31 23:59:59








Related examples in the same category

1. Date and Time Sizes, Formats, and Ranges
2.Define and check the date data type
3.Define and use Date data type
4.Show current date
5.Use date data type
6.Defining Set Membership:Finding Records in a Set
7.Performing Range Tests 3
8.Performing Range Tests 1
9.Performing Range Tests 2
10.Convert Date to int
11.The date/time data types
12.Date and Time Column Types