Datatype conversion functions  Mathematical functions

Chapter 3: SQL Reference

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.

Table 3-4: 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



Copyright © 2011. Sybase Inc. All rights reserved. Mathematical functions

View this document as PDF