SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-38
DATEFORMAT Function
DATEFORMAT Function
The DATEFORMAT function returns a datetime value as a character string literal in the
DEFAULT, USA, or EUROPEAN format. The data type of the result is CHAR.
DATEFORMAT is an SQL/MX extension.
datetime-expression
is an expression that evaluates to a datetime value of type DATE, TIME, or
TIMESTAMP. See Datetime Value Expressions on page 6-39.
DEFAULT | USA | EUROPEAN
specifies a format for a datetime value. See Datetime Literals on page 6-64.
Examples of DATEFORMAT
•
Convert a datetime literal in DEFAULT format to a string in USA format:
DATEFORMAT (TIMESTAMP '1996-06-20 14:20:20.00', USA)
The function returns this string literal:
'06/20/1996 02:20:20.00 PM'
•
Convert a datetime literal in DEFAULT format to a string in European format:
DATEFORMAT (TIMESTAMP '1996-06-20 14:20:20.00', EUROPEAN)
The function returns this string literal:
'20.06.1996 14.20.20.00'
DATEFORMAT (datetime-expression,{DEFAULT | USA | EUROPEAN})