current_bigtime

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_bigtime()

Examples

Example 1 – Finds the current bigtime:

select current_bigtime())
------------------------------
10:32:00.010101AM

Example 2 – Finds the current bigtime:

select datepart(us, current_bigtime())
------------------------------
01010

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.