Neoview ODBC Drivers Manual (R2.5)

Table 7-13 Time and Date Functions
SQL Equivalent FunctionODBC Function
CURRENT_DATECURDATE, CURRENT_DATE
CURRENT_TIMECURTIME, CURRENT_TIME
DAYDAY
EXTRACTEXTRACT
Not supportedDAYNAME
Not supportedDAYOFMONTH
DAYOFWEEKDAYOFWEEK
DAYOFYEARDAYOFYEAR
HOURHOUR
MINUTEMINUTE
MONTHMONTH
MONTHNAMEMONTHNAME
Supported, but no equivalent SQL function.NOW
QUARTERQUARTER
SECONDSECOND
Not supportedTIMESTAMPADD
Not supportedTIMESTAMPDIFF
WEEKWEEK
Table 7-14 System Functions
SQL Equivalent FunctionODBC Function
Not supported in this release.DATABASE
Not supported in this release.IFNULL
USERUSER
CONVERT Function
The HP Neoview ODBC driver uses the SQL CAST function to support the ODBC CONVERT
function. The ODBC CONVERT function has the following format:
{ fn CONVERT( value_exp, data_type ) }
The SQL CAST has this format:
CAST( {value_exp | NULL } AS data_type )
SQL translates the CONVERT syntax to the CAST syntax, converting the data type argument to
its equivalent SQL value. For example, if the ODBC data type parameter for character data is an
integer value (SQL_CHAR or 1), the equivalent SQL data type is a string literal with a value of
CHARACTER.
ODBC Data Types
For information on SQL data types, see the HP Neoview SQL Reference Manual.
70 HP Neoview ODBC Drivers Conformance