current_time

Finds and returns the current time as it exists on the server.

Syntax

current_time()

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_time.

Related concepts
Date and Time Datatypes
Related reference
dateadd
datename
datepart
getdate