Date Time MySQL

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