Returns the current date.
current_date()
Identifies the current date with datename:
1> select datename(month, current_date()) 2> go
------------------------------ August
Identifies the current date with datepart:
1> select datepart(month, current_date()) 2> go
----------- 8 (1 row affected)
Finds the current date as it exists on the server.
ANSI SQL – Compliance level: Entry-level compliant.
Any user can execute current_date.
Datatypes Date and time datatypes
Commands select, where clause
Functions dateadd, datename, datepart, getdate
Copyright © 2005. Sybase Inc. All rights reserved. |