TIBCO Data Virtualization® Adapter Online Help > TDV MySQL Adapter > MySQL Function Support > MySQL Date Function Support
 
MySQL Date Function Support
TDV supports the date functions listed in the table below for MySQL.
MySQL Date Function
Notes
CURRENT_DATE
 
CURRENT_TIME
 
CURRENT_TIMESTAMP
 
DATEDIFF
DATEDIFF (enddate, startdate)
DAY
 
MONTH
 
UTC_TO_TIMESTAMP
 
YEAR