Contents Index COOPERATIVE_COMMITS option [database] DATE_ORDER option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

DATE_FORMAT option [compatibility]


Function 

Sets the format for dates retrieved from the database.

Allowed values 

String

Scope 

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Default 

'YYYY-MM-DD'. This corresponds to ISO date format specifications.

Description 

The format is a string using the following symbols:

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
d Single digit day of week, (0 = Sunday, 6 = Saturday)
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[.ss..] Seconds and parts of a second
aa AM or PM (12 hour clock)
pp PM if needed (12 hour clock)
jjj Day of the year, from 1 to 366

Each symbol is substituted with the appropriate data for the date that is being formatted.

For symbols that represent character data (such as mmm), you can control the case of the output as follows:

For symbols that represent numeric data, you can control zero-padding with the case of the symbols:

Examples 

Contents Index COOPERATIVE_COMMITS option [database] DATE_ORDER option [compatibility]