Neoview ODBC Drivers Manual (R2.2)

Table 5-12 String Functions (continued)
SQL Equivalent FunctionODBC Function
TRIM...TRAILINGRTRIM
Not supportedSOUNDEX
SPACESPACE
SUBSTRINGSUBSTRING
UPPER | UPSHIFTUCASE
ODBC string functions in queries can return unexpected results for fixed-length (CHAR) column names, because
SQLpads a fixed-length string with blanks up to the length of the definition. Therefore, the results from some ODBC
string functions can include trailing blanks at the end of the string. Use the RTRIM function in queries to cause SQL
to trim the extra blanks from the column names.
Table 5-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 5-14 System Functions
SQL Equivalent FunctionODBC Function
Not supported in this release.DATABASE
Not supported in this release.IFNULL
USERUSER
56 HP Neoview ODBC Drivers Conformance