Returns the the current time.
current_time()
Finds the current time:
1> select current_date() 2> go
-------------------------- Aug 29 2003 (1 row affected)
Use with datename:
1> select datename(minute, current_time()) 2> go
------------------------------ 45 (1 row affected)
Used to find the current time as it exists on the server
ANSI SQL – Entry level Compliance.
Any user can execute current_time.
Datatypes Date and time datatypes
Commands select, where clause