TIMESTAMPDIFF

​

Syntax

​

Timestampdiff quoted (scalar)

"timestampdiff"(unit, start, end)

• Quote the function name and pass a STRING unit, for example "timestampdiff"('hour', start, end). The unquoted TIMESTAMPDIFF keyword form is rejected.

​

Arguments

​

Returns

• Type: BIGINT
• NULL behavior: NULL unit or temporal arguments yield NULL; unknown unit raises an error. Unrepresentable temporal values or overflowing microsecond differences yield NULL.

​

Properties

​

Units

• Input unit: Temporal values
• Output unit: Specified complete elapsed units

​

Usage notes

• Arguments are ordered as (unit, start, end).
• Calendar units use complete units; shorter fixed units truncate incomplete elapsed intervals.

​

Examples

​

Alias calling form: TIMESTAMPDIFF

• The function name is double-quoted to select its ordinary function-call spelling.

SELECT "timestampdiff"('hour', TIMESTAMP '2024-07-15 22:00:00', TIMESTAMP '2024-07-16 00:30:00') AS result;

​

Reverse the start and end times

SELECT "timestampdiff"('hour', TIMESTAMP '2024-03-15 03:00:00', TIMESTAMP '2024-03-15 01:00:00') AS hours;

​

Limitations

• Use "timestampdiff"('hour', start, end) or TIMESTAMP_DIFF('hour', start, end). The unquoted TIMESTAMPDIFF(HOUR, start, end) form is rejected.