◄Key► ◄Summary► ◄Up► ◄Contents► ◄Index► ◄Back► ──────────────────────────────────────────────────────────────────────────── The possible values of date-format are: DEF determined by country code USA mm/dd/yyyy hh:mm xM (AM/PM) EUR dd.mm.yyyy hh.mm.ss ISO yyyy-mm-dd hh.mm.ss JIS yyyy-mm-dd hh:mm:ss LOC Local form When DEF or LOC is specified, these are the formats used: LOC date LOC time DEF date DEF time 001 USA mm-dd-yyyy hh:mm:ss mm/dd/yyyy hh:mm xM (AM/PM) 002 Canada/Fr dd-mm-yyyy hh.mm.ss yyyy-mm-dd hh.mm.ss 044 UK dd/mm/yyyy hh:mm:ss dd/mm/yyyy hh:mm:ss 033 France dd/mm/yyyy hh:mm:ss dd.mm.yyyy hh.mm.ss 049 Germany dd/mm/yyyy hh.mm.ss yyyy-mm-dd hh.mm.ss 034 Spain dd/mm/yyyy hh:mm:ss dd/mm/yyyy hh:mm:ss 039 Italy dd/mm/yyyy hh:mm:ss dd/mm/yyyy hh:mm:ss 046 Sweden dd/mm/yyyy hh.mm.ss yyyy-mm-dd hh.mm.ss 045 Denmark dd-mm-yyyy hh.mm.ss yyyy-mm-dd hh.mm.ss 047 Norway dd/mm/yyyy hh.mm.ss dd.mm.yyyy hh.mm.ss 031 Netherlands dd-mm-yyyy hh:mm:ss yyyy-mm-dd hh.mm.ss 032 Belgium dd/mm/yyyy hh:mm:ss dd/mm/yyyy hh:mm:ss See the IBM OS/2 Database Manager SQL Reference for more details. This directive is ignored if NOSQL is specified. -♦-