ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-16
Functions
•
TIMESTAMPADD
•
TIMESTAMPDIFF
•
YEAR
In all of the syntax descriptions that follow, date-expression or time-expression
can be a date or time literal, a column name, or the result of another function.
CURDATE
The CURDATE function has the following syntax:
The CURDATE function returns the current date.
CURTIME
The CURTIME function has the following syntax:
The CURTIME function returns the current time.
DAYOFMONTH
The DAYOFMONTH function has the following syntax:
The DAYOFMONTH function evaluates date-expression and returns the
corresponding day of the month as an integer value.
DAYOFWEEK
The DAYOFWEEK function has the following syntax:
The DAYOFWEEK function evaluates date-expression and returns the
corresponding day of the week as an integer value, where 1 represents Sunday.
HOUR
The HOUR function has the following syntax:
The HOUR function returns the hour in time-expression as an integer.
CURDATE ( )
CURTIME ( )
DAYOFMONTH ( date-expression )
DAYOFWEEK ( date-expression )
HOUR ( time-expression )