DATE - Date values

Date fields allow storing date values. The size for a date field influences only the standard presentation of the date, i.e. the date to string conversion. Following size definitions are possible:

8: "2002-09-14"

6,7: "02-09-14"

4,5: "02-09"

2,3: "02"

Independent on the size the date is stored always as 4 byte integer value containing the number of days since 1870-01-01.

ODABA supports different string representation for date:

Standard: yyyy-mm-dd or yyyymmdd

English: mm/dd/yyyy

German: dd.mm.yyyy

The type of date is determined from the separator used.