current_time

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

Syntax

current_time()

Example 1 – Finds the current time:

1> select current_time()
2> go

------------------------ 
            12:29PM

(1 row affected)

Example 2 – Use with datename:

1> select datename(minute, current_time())
2> go

------------------------------ 
45

(1 row affected)

See also select, where clause in Reference Manual: Commands.

ANSI SQL – Compliance level: Entry-level compliant.

Any user can execute current_time.