Date formats and currency codes

Dates are typically written in one of these formats:

• DDMMYYYY (day, month, year)
• MMDDYYYY (month, day, year)
• YYYYMMDD (year, month, day)

Databases store dates in the sequence of YYYYMMDD, but then adjust the sequence of the day, month, and year elements according to the country. The separator can vary, for example, a period separates YYYY from MM and from DD in Hungary.

Currency codes must use the ISO 4217 standard, which defines three alpha currency designators. The first two letters of the code are the ISO 3166-1 alpha-2 country codes, for example, US (United States), with the third letter the initial of the currency, D (dollar). There is also a three-digit code number assigned to each currency. For example, 840 is the numeric code for the US dollar.