SUBTIME

Syntax

SUBTIME(expr1,expr2)

Description

SUBTIME() returns expr1 - expr2 expressed as a value in the same format as expr1. expr1 is a time or datetime expression, and expr2 is a time expression.

Examples

SELECT SUBTIME('2007-12-31 23:59:59.999999','1 1:1:1.000002'); +--------------------------------------------------------+ | SUBTIME('2007-12-31 23:59:59.999999','1 1:1:1.000002') | +--------------------------------------------------------+ | 2007-12-30 22:58:58.999997 | +--------------------------------------------------------+  SELECT SUBTIME('01:00:00.999999', '02:00:00.999998'); +-----------------------------------------------+ | SUBTIME('01:00:00.999999', '02:00:00.999998') | +-----------------------------------------------+ | -00:59:59.999999 | +-----------------------------------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}