ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-17
Functions
MINUTE
The MINUTE function has the following syntax:
The MINUTE function returns the minute in time-expression as an integer.
MONTH
The MONTH function has the following syntax:
The MONTH function returns the month in date-expression as an integer.
NOW
The NOW function has the following syntax:
The NOW function returns the current datetime as a timestamp value.
QUARTER
The QUARTER function has the following syntax:
The QUARTER function returns the quarter of the year in the range 1 to 4, in which 1
represents January 1 through March 31.
SECOND
The SECOND function has the following syntax:
The SECOND function returns the second in time-expression as an integer.
TIMESTAMPADD
The TIMESTAMPADD function has the following syntax:
The TIMESTAMPADD function adds a number of intervals to a timestamp value.
MINUTE ( time-expression )
MONTH ( date-expression )
NOW ( )
QUARTER (date-expression )
SECOND ( time-expression )
TIMESTAMPADD ( interval, integer-exp, timestamp-exp )