community.borland.com

Article #25748: What are the acceptable formats for inserting into date fields

Problem:
I don't know how to format data for dates

Solution:
mm-dd-yy          (sliding window pertains)
mm-dd-yyyy
mm/dd/yy          (sliding window pertains)
mm/dd/yyyy
Month dd, yy      (sliding window pertains)
Month dd, yyy
dd-Mon-yyyy
dd.mm.yy           (sliding window pertains)
yyyy mm dd
mon dd             (year is current year)
dd mon             (year is current year)
mm dd              (year is current year)
mm dd yy           (sliding window pertains)
mm dd yyyy
now                    
today                  
tomorrow          
yesterday 

InterBase uses a sliding window of 50 yearsfor dates. So any time you enter a 2 digit year the century of the date is determined by this sliding window. For example,
in the year 2000, any date with a year of 0-49 is assumed to be in the 21st century. Any date with the year 50-99 is assumed to be in the 20th century.

Last Modified: 15-DEC-00