The TIMESTAMP column type : TIMESTAMP « Date Time « SQL / MySQL






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

The TIMESTAMP column type

     

Type                  Description
 
TIMESTAMP(14)         YYYYMMDDHHMMSS 
 
TIMESTAMP(12)         YYMMDDHHMMSS 
 
TIMESTAMP(10)         YYMMDDHHMM 
 
TIMESTAMP(8)          YYYYMMDD 
 
TIMESTAMP(6)          YYMMDD 
 
TIMESTAMP(4)          YYMM 
 
TIMESTAMP(2)          YY








Related examples in the same category

1.Displaying TIMESTAMP Values in Readable Form
2.If you modify multiple records, the TIMESTAMP values in all of them will be updated:
3.Table with TIMESTAMP data type
4.Add Microsecond to time
5.Records created from 1 PM to 4 PM:
6.Records modified within the last 12 hours: