current_bigtime

Description

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

Parameters

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

Finds the current date as it exists on the server.

Standards

ANSI SQL – Compliance level: Entry-level compliant.

Permissions

Any user can execute current_date.

See also