Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. The INTERVAL clause requires an expression, which must be a time value in an acceptable format, and a type value
                    format
MICROSECOND              
SECOND                   
MINUTE                   
HOUR                     
DAY                      
MONTH                    
YEAR                     
SECOND_MICROSECOND       '.'
MINUTE_MICROSECOND       '.'
MINUTE_SECOND            ':'
HOUR_MICROSECOND         '.'
HOUR_SECOND              '::'
HOUR_MINUTE              ':'
DAY_MICROSECOND          '.'
DAY_SECOND               ' ::'
DAY_MINUTE               ' :'
DAY_HOUR                 ' '
YEAR_MONTH               '-'