Reference - Format Strings
Formatting Date and Time
To format a date or time, use the following table to determine the correct variable(s) to use. They may be used with other text, including punctuation.
The date format
09/03/01
would be entered into the format field as
%m/%d/%y
The date format
Monday - September 03, 2001
would be entered as
%A - %B %d, %Y
Formatting Decimals
Decimals can be formatted using the %.#f notation where # is the number of decimal places appearing after the decimal point.
To display zero decimal places:
%.0f
To display one decimal place:
%.1f
And so on for any number of decimal places.
Note for Oracle users: ODBC reports Oracle integers as doubles.
As such, Oracle integers should be formatted using the above notation.
Formatting Options
| %a | Abbreviated weekday name |
|---|---|
| %A | Full weekday name |
| %b | Abbreviated month name |
| %B | Full month name |
| %c | Date and time representation appropriate for locale |
| %d | Day of month as decimal number (01 - 31) |
| %H | Hour in 24-hour format (00 - 23) |
| %I | Hour in 12-hour format (01 - 12) |
| %j | Day of year as decimal number (001 - 366) |
| %m | Month as decimal number (01 - 12) |
| %M | Minute as decimal number (00 - 59) |
| %p | A.M./P.M. indicator for 12-hour clock |
| %S | Second as decimal number (00 - 59) |
| %w | Weekday as decimal number (0 - 6 Sunday is 0) |
| %x | Date representation for current locale |
| %X | Time representation for current locale |
| %y | Year without century, as decimal number (00 - 99) |
| %Y | Year with century, as decimal number |
| %% | Percent sign |
