Sets the format for TIMESTAMP WITH TIME ZONE values retrieved from the database.
A temporary setting for the current user is established by the ODBC, JDBC, and OLE DB drivers ('yyyy-mm-dd hh:nn:ss.ssssss +hh:nn').
A temporary setting for the current user is established by the .NET provider ('YYYY-MM-DD HH:NN:SS.SSSSSS+HH:NN').
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY PUBLIC OPTION||Yes||Yes, with SET ANY PUBLIC OPTION|
|Allowed to set temporarily?||Yes, with SET ANY PUBLIC OPTION||Yes (current connection only)||No|
The format is a string using the following symbols:
|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 (1 = Sunday, 7 = Saturday).|
|DD||Two-digit day of month.|
|DDD[d...]||Character short form for day of the week.|
|JJJ||Day of the year, from 1 to 366.|
|HH||Two-digit hours, or two digit hours of time zone offset if after '+'.|
|NN||Two-digit minutes, or two digit minutes of time zone offset if after '+'.|
|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). Omit AA and PP for 24 hour time.|
|PP||PM if needed (12 hour clock). Omit AA and PP for 24 hour time.|
|HH||Two-digit hours (time zone offset).|
|NN||Two-digit minutes (time zone offset).|
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:
Type the symbol in all uppercase to have the format appear in all uppercase. For example, MMM produces JAN.
Type the symbol in all lowercase to have the format appear in all lowercase. For example, mmm produces jan.
Type the symbol in mixed case to have the database server choose the appropriate case for the language that is being used. For example, in English, typing Mmm produces May, while in French it produces mai.
If the character data is multibyte, the length of each symbol reflects the number of characters, not the number of bytes. For example, the mmm symbol specifies a length of three characters for the month.
For symbols that represent numeric data, you can control zero-padding with the case of the symbols:
Type the symbol in same-case (such as MM or mm) to allow zero padding. For example, yyyy/mm/dd could produce 2002/01/01.
Type the symbol in mixed case (such as Mm) to suppress zero padding. For example, yyyy/Mm/Dd could produce 2002/1/1.
If the first two digits of the fractional seconds are mixed case (such as Ss or sSssss) then trailing zeros are removed. For example, hh:nn:ss.Sss could produce 12:34:56.1.