On Wed, April 25, 2007 11:50 am, Gary Warner said:
> Does anyone have a suggestion for being able to store "dates" parsed
> from email headers that would handle a fairly international set of
> formats? Or do I need to do date-conversion prior to trying to store?
>
> currently choking on things like "Ene-18-2007" (Enero = January) and
> "Sau-20-2007" or "Oca-29-2007" or (I have no idea what "Sau" or "Oca"
> are) and we especially don't seem to like dates that my 7-bit Windows
> window calls things like: "â¤ââ-11-2007"
I'd say either store them as a string (If you don't need to do date
comparisons), or find a date conversion package that can handle
everything. (I'd suggest taking a look at Perl modules, they are likely
to have something which you could integrate fairly easily.)
There are a million and one different date formats; either you spend all
your time figuring out new ones, or you support a few common ones and
spend your time on other things. The Postgres team follows the latter.
Daniel T. Staal
---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------