The date functions manipulate values of the datatype 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.
Function |
ASE |
ASA |
ASIQ |
dir_con |
db2 |
|---|---|---|---|---|---|
dateadd |
Y |
Y |
Y |
C |
N |
datediff |
Y |
Y |
Y |
C |
N |
datename |
Y |
Y |
N |
C |
N |
datepart |
Y |
Y |
Y |
C |
N |
