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

Example 1 – Find the current bigdatetime:

select current_bigdatetime())
------------------------------
Nov 25 1995 10:32:00.010101AM

Example 2 – Find the current bigdatetime:

select datepart(us, current_bigdatetime())
------------------------------
010101

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.