TIBCO Data Virtualization® Adapter Online Help
>
TDV Sybase Adapter
>
Sybase Function Support
>
Sybase Date Function Support
Sybase Date Function Support
TDV supports the date functions listed in the table below for Sybase.
Sybase Date Function
Notes
CURRENT_TIMESTAMP
DATEDIFF
DATEDIFF (datepart, startdate, enddate)
Sybase produces correct (standard) results for year, month, day date parts and
incorrect
results for hour, minute, second date parts.
DAY
MONTH
YEAR