current_bigdatetime

Finds the current date as it exists on the server, and returns a bigtime value representing the current time with microcecond precision. The accuracy of the current time portion is limited by the accuracy of the system clock.

Syntax

current_bigdatetime()

Examples

Usage

See also select, where clause in Reference Manual: Commands.

Standards

ANSI SQL – Compliance level: Entry-level compliant.

Permissions

Any user can execute current_date.

Related concepts
Date and Time Datatypes
Related reference
dateadd
datediff
datepart
datename
current_bigtime