Date Functions

The date functions manipulate values of the datatypes datetime or smalldatetime.

The getdate() function is always expanded by the local server; the presence of this builtin function does not cause a query to be eliminated from quickpass mode optimizations, however.

Server Class Support for Date Functions

Function

ASE

ASA

ASIQ

dir_con

dateadd

Y

Y

Y

C

datediff

Y

Y

Y

C

datename

Y

Y

N

C

datepart

Y

Y

Y

C
Parent topic: Functions