AGO

Subtracts the specified interval from the current timestamp, and returns it as a TIMESTAMPTZ value. For more information, see Arithmetic with intervals.

Syntax

AGO(<interval>)

Parameters

Parameter	Description
`<interval>`	The `interval` as a literal to subtract from the current timestamp.

Return Type

TIMESTAMPTZ

Example

The following example assumes that the current Unix timestamp is 2023-03-03 14:42:31.123456 UTC.

SET time_zone = 'Europe/Berlin';
SELECT CURRENT_TIMESTAMP;  --> 2023-03-03 15:42:31.123456+01
SELECT AGO('1h');  --> 2023-03-03 14:42:31.123456+01

APACHE_DATASKETCHES_HLL_MERGE

CURRENT_DATE

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return Type

Example

​Syntax

​Parameters

​Return Type

​Example

Syntax

Parameters

Return Type

Example