current_bigdatetime

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

Parameters

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

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