MICROSECONDS_DIFF

Description

Calculates the microsecond difference between two datetime values. The result is the number of microseconds from <start_date> subtracted from <end_date>.

Syntax

MICROSECONDS_DIFF(<enddate>, <startdate>)

Parameters

Parameter	Description
<end_date>	The end time, of type DATETIMEV2
<start_date>	The start time, of type DATETIMEV2

Return Value

Returns an INT type representing the microsecond difference between the two times.

• Returns a positive number if <end_date> is greater than <start_date>.
• Returns a negative number if <end_date> is less than <start_date>.
• 1 second = 1,000,000 microseconds.

Example

SELECT MICROSECONDS_DIFF('2020-12-25 21:00:00.623000', '2020-12-25 21:00:00.123000');

+-----------------------------------------------------------------------------------------------------------------------------+
| microseconds_diff(cast('2020-12-25 21:00:00.623000' as DATETIMEV2(3)), cast('2020-12-25 21:00:00.123000' as DATETIMEV2(3))) |
+-----------------------------------------------------------------------------------------------------------------------------+
|                                                                                                                      500000 |
+-----------------------------------------------------------------------------------------------------------------------------+