Mega Code Archive

 

Categories / MySQL / Date Time

 

The INTERVAL clause requires an expression, which must be a time value in an acceptable format, and a type value

<type>                   <expression> format MICROSECOND              <microseconds> SECOND                   <seconds> MINUTE                   <minutes> HOUR                     <hours> DAY                      <days> MONTH                    <months> YEAR                     <years> SECOND_MICROSECOND       '<seconds>.<microseconds>' MINUTE_MICROSECOND       '<minutes>.<microseconds>' MINUTE_SECOND            '<minutes>:<seconds>' HOUR_MICROSECOND         '<hours>.<microseconds>' HOUR_SECOND              '<hours>:<minutes>:<seconds>' HOUR_MINUTE              '<hours>:<minutes>' DAY_MICROSECOND          '<days>.<microseconds>' DAY_SECOND               '<days> <hours>:<minutes>:<seconds>' DAY_MINUTE               '<days> <hours>:<minutes>' DAY_HOUR                 '<days> <hours>' YEAR_MONTH               '<years>-<months>'