ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-15
Functions
For a complete list of the CORE SQL functions, see Appendix A, Summary of Support
for ODBC Features.
Date Functions
The NonStop ODBC Server supports the following CORE SQL date functions, which
manipulate datetime data:
•
CURDATE
•
CURTIME
•
DAYOFMONTH
•
DAYOFWEEK
•
HOUR
•
MINUTE
•
MONTH
•
NOW
•
QUARTER
•
SECOND
HOUR See HOUR on page 3-16
MINUTE See MINUTE
on page 3-17
MONTH See MONTH
on page 3-17
NOW See NOW
on page 3-17
QUARTER See QUARTER
on page 3-17
SECOND See SECOND
on page 3-17
TIMESTAMPADD See TIMESTAMPADD
on page 3-17
TIMESTAMPDIFF See TIMESTAMPDIFF
on page 3-18
YEAR See YEAR
on page 3-19
Mathematical EXP Fully supported
MOD Fully supported
PI Fully supported
String UCASE Fully supported
System DATABASE Fully supported
USER Fully supported
Conversion CONVERT SeeConversion Function
on page 3-23
Table 3-5. Supported CORE SQL Functions (page2of2)
Function Type Function Comments