cobol2.hlp (Table of Contents; Topic list)
Important Notice
The pages on this site contain documentation for very old MS-DOS software, purely for historical purposes. If you're looking for up-to-date documentation, particularly for programming, you should not rely on the information found here, as it will be woefully out of date.
SQLFORMAT Details (↑ SQL)
 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.
                                    -♦-