SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-4
Datetime Functions
Datetime Functions
These functions use either a datetime value expression as an argument or return a
result of datetime data type:
CONVERTTIMESTAMP Function on
page 9-36
Converts a Julian timestamp to a TIMESTAMP
value.
CURRENT Function
on page 9-40 Returns the current timestamp. You can also use
the CURRENT_TIMESTAMP Function
.
CURRENT_DATE Function
on
page 9-41
Returns the current date.
CURRENT_TIME Function
on
page 9-42
Returns the current time.
CURRENT_TIMESTAMP Function
on
page 9-43
Returns the current timestamp. You can also use
the CURRENT Function
.
DATEFORMAT Function
on page 9-44 Formats a datetime value for display purposes.
DAY Function
on page 9-45 Returns an integer value in the range 1 through
31 that represents the corresponding day of the
month. You can also use DAYOFMONTH.
DAYNAME Function
on page 9-46 Returns the name of the day of the week from a
date or timestamp expression.
DAYOFMONTH Function
on page 9-47 Returns an integer value in the range 1 through
31 that represents the corresponding day of the
month. You can also use DAY.
DAYOFWEEK Function
on page 9-48 Returns an integer value in the range 1 through 7
that represents the corresponding day of the
week.
DAYOFYEAR Function
on page 9-49 Returns an integer value in the range 1 through
366 that represents the corresponding day of the
year.
EXTRACT Function
on page 9-70 Returns a specified datetime field from a
datetime value expression or an interval value
expression.
HOUR Function
on page 9-78 Returns an integer value in the range 0 through
23 that represents the corresponding hour of the
day.
JULIANTIMESTAMP Function
on
page 9-80
Converts a datetime value to a Julian timestamp.
MINUTE Function
on page 9-100 Returns an integer value in the range 0 through
59 that represents the corresponding minute of
the hour.