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.
date-format can be used to convert the binary values into date strings that match the appropriate format for the end users.