MILLISECONDS_DIFF

Overview

Returns the number of milliseconds between two timestamps. Result = first argument - second argument.

Syntax

MILLISECONDS_DIFF(<end>, <start>)

Parameters

• <end>: DATE or TIMESTAMP type, the minuend.
• <start>: DATE or TIMESTAMP type, the subtrahend.

Returns NULL if either argument is NULL.

Examples

SELECT milliseconds_diff('2024-01-01 00:00:01.500', '2024-01-01 00:00:00'); -- 1500 SELECT milliseconds_diff('2024-01-01 00:00:00', '2024-01-01 00:00:01.500'); -- -1500 SELECT milliseconds_diff('2024-01-02', '2024-01-01'); -- 86400000 SELECT milliseconds_diff(NULL, '2024-01-01'); -- NULL

Related Documentation

• DATEDIFF — general date difference function supporting multiple time units
• SECONDS_DIFF, MINUTES_DIFF