Date and Time Column Types : Date Type « Date Time « SQL / MySQL






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

Date and Time Column Types

     

Type                 Description
 
DATETIME             YYYY-MM-DD HH:MM:SS from 1000-01-01 00:00:00 to 9999-12-31 23:59:59 
 
DATE                 YYYY-MM-DD from 1000-01-01 to 9999-12-31 
 
TIMESTAMP            YYYYMMDDHHMMSS 
 
TIME                 HH:MM:SS 
 
YEAR                 YYYY








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 Sizes, Formats, and Ranges