company logo

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.