Returns 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)
Finds the current time as it exists on the server
ANSI SQL – Compliance level: Entry-level compliant.
Any user can execute current_time.
Datatypes Date and time datatypes
Commands select, where clause
Functions dateadd, datename, datepart, getdate
Copyright © 2005. Sybase Inc. All rights reserved. |