Used for handling non-default style character-strings representing the date and time. This is predicated on handling date and time styles from different nations and/or languages.

Depending on the nation and/or the language the binary value for a datetime, date, or time may be converted to several different date string representations.

For example, using 4-character years with no time component:

  • mm/dd/yyyy (U.S.)
  • dd/mm/yyyy (British/French)
  • dd.mm.yyyy (German)

By properly applying date-formats to date strings from different sources it is possible to control the interpretation of date strings so that the binary values stored in a database match one another.

Likewise, the date-format can be used to convert the binary values into date strings that match the appropriate format for the end users.

See also: https://en.wikipedia.org/wiki/Date_format_by_country

history | excerpt history