[[Property:title|DATE TIME to STRING Conversion]]
[[Property:weight|3]]
[[Property:uuid|88972ba4-694b-8558-b0c8-87b1fc40afc4]]
The classes TIME, DATE, and DATE_TIME provide a query formatted_out which can be used to retrieve a string containing the date or time in a format specified by a string or format conversion codes that the caller provides as an argument. The conversion is done in the DATE_TIME_CODE_STRING class. So for example, if a DATE instance referenced by my_date has a value of February 3, 2008, then applying the query:
my_date.formatted_out ("[0]dd mmm yyyy")
will return the string:
03 FEB 2008
The following table lists format conversion codes.
{|
|-
| '''Code'''
| '''Description'''
|-
| dd
| day - numeric
|-
| [0]dd
| day - numeric (padded with '0' to 2 figures)
|-
| ddd
| day - text (3 letters e.g "MON", "TUE")
|-
| yyyy
| year - numeric (4 figures)
|-
| yy
| year - numeric (2 figures)
|-
| mm
| month - numeric
|-
| [0]mm
| month - numeric (padded with '0' to 2 figures)
|-
| mmm
| month - text (3 letters e.g "DEC", "JAN")
|-
| hh
| hour - numeric (24 hour clock scale by default)
|-
| [0]hh
| hour - numeric (padded with '0' to 2 figures)
|-
| hh12
| hour - numeric (12 hour clock scale)
|-
| mi
| minute - numeric
|-
| [0]mi
| minute - numeric (padded with '0' to 2 figures)
|-
| ss
| seconds - numeric
|-
| [0]ss
| seconds - numeric (padded with '0' to 2 figures)
|-
| ff
| fractional seconds - numeric (precise to figures)
|-
| am
| meridiem indicator. Includes "AM" for ante meridiem times (before noon) and "PM" for post meridiem times (after noon).
|-
| ':', '/', '-' and ','
| separators e.g. "03/FEB/08"
|}
These are some examples of output with their associated format code:
{|
|-
| '''Code'''
| '''Output'''
|-
| yy/mm/dd
| 08/2/3
|-
| mmm-[0]dd-yy
| FEB-03-08
|-
| dd,mm,yyyy
| 3,2,2008
|-
| hh-mi-ss
| 13-6-32
|-
| hh12,mi,ss
| 1,6,32
|-
| hh12:[0]mi:[0]ss:ff2 am
| 1:06:32.25 PM
|-
| [0]hh:[0]mi:[0]ss.ff3
| 13:06:32.248
|-
| [0]mm/dd/yy hh12:mi:ss.ff3
| 02/3/08 1:6:32.248
|}