DATE

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

Hi,
I would like to save my date notations like: DD/MM/YY
In table creation I can choose short notation but then dates are saved
like DD/MM/YYYY.

Thanks
JP
 
Actually, dates aren't stored with any format: they're 8 byte floating point
numbers, where the integer portion represents the date as the number of days
relative to 30 Dec, 1899, and the decimal portion represents the time as a
fraction of a day.

Ofer's suggestion of setting the format to dd/mm/yy is likely all you need.
 
Back
Top