Alphabetical list of options
214
Symbol Description
yy Two digit year
Yyyy Four digit year
Mm Two digit month, or two digit minutes if following a colon (as in
’hh:mm’)
Mmm[m...] Character short form for months—as many characters as there are
m's
dd Two digit day of month
Ddd[d...] Character short form for day of the week
hh Two digit hours
nn Two digit minutes
ss.ssssss Seconds and fractions of a second, up to six decimal places. Not all
platforms support timestamps to a precision of six places.
aa am or pm (12 hour clock)
pp Pm if needed (12 hour clock)
f Use French days and months (deprecated)
Each symbol is substituted with the appropriate data for the timestamp that is
being formatted. Any format symbol that represents character rather than
digit output can be put in uppercase, which causes the substituted characters
to also be in uppercase. For numbers, using mixed case in the format string
suppresses leading zeros.
TRUNCATE_DATE_VALUES option
To change the storage of time values within DATE data type values.
ON, OFF
ON for databases created with Version 7 or later software, or upgraded to
Version 7 or later.
OFF for older databases
"DATE_FORMAT option" on page 181
"DATE data type" on page 281
When the option is set to ON, columns or variables declared as DATE data
types have no hours and minutes stored.
Function
Allowed values
Default
See also
Description
To Next Page
Loading...