SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-14
DATEFORMAT Function
DATEFORMAT Function
DATEFORMAT is a function that formats a date-time value in DEFAULT, USA, or
EUROPEAN format. DATEFORMAT returns a value of type CHAR.
You can use DATEFORMAT wherever an arithmetic expression is allowed.
date-time-expression
is an expression that evaluates to a value of type DATETIME, DATE, TIME, or
TIMESTAMP.
{ DEFAULT }
{ USA }
{ EUROPEAN }
specifies a display format for a date-time value. For a description of the formats,
see Date-Time Literals on page D-10.
The default is DEFAULT.
Example—DATEFORMAT
This function call converts a date-time literal in DEFAULT format to USA format:
DATEFORMAT( DATETIME "1989-06-20:10:20" YEAR TO MINUTE, USA )
It returns:
06/20/1989 10:20 AM
{ DEFAULT }
DATEFORMAT ( date-time-expression, { USA } )
{ EUROPEAN }