SECONDS_BETWEEN

Purpose

This function returns the number of seconds between two timestamps.

Syntax

seconds_between::=

Usage notes

  • If a timestamp timestamp1 is earlier than timestamp timestamp2, then the result is negative.

  • Additionally, the result contains the fractional seconds difference between the two arguments.

  • For data type TIMESTAMP WITH LOCAL TIME ZONE this function is calculated internally within UTC.

Example

SELECT SECONDS_BETWEEN(TIMESTAMP '2000-01-01 12:01:02.345',
                       TIMESTAMP '2000-01-01 12:00:00') SB;