Re: Formatting a DATE differently using SQL

Another thing to consider in using LOCAL and hoping you have that set to
mmddyy is have you set up the error trapping for dates that fall outside
of the range limited by the automatic conversion to MM/DD/YY?
For example try this:
values char(date('2013-01-31'), local)
That looks good. Now replace that with:
values char(date('2070-01-31'), local)
and it bombs.
However the following works:
values claydate(date('2070-01-31'))
and returns 01/31/70
Whether or not that's what you want is your call.

This is acceptable:
values char(date('2039-12-31'), local)
This is not:
values char(date('2040-01-01'), local)

This is acceptable:
values char(date('1940-01-01'), local)
This is not:
values char(date('1939-12-31'), local)

Keep in mind that if you work for 30 years from today your projected
retirement date is outside the acceptable range.


Rob Berendt