On 3/1/07, Michael Van Canneyt <[EMAIL PROTECTED]> wrote:
When doing a query, i.e. in a SQL statement, you must indeed use
MM/DD/YYYY. If you use parametrized queries, you must use the
internal representation.
That's the one! We had some very huge and complex stored procedures
(couple hundred lines or sql) that used or generated dates on the fly
and was always an issue. And no, I didn't write those stored
procedure, but had to maintain them - a nightmare. I still think it
is weird though. Installing a server in a location other that the US
and other than US regional settings, yet you have to convert to US
format dates.
Don't you just love software developers and the power that goes with it. :-)
--
Graeme Geldenhuys
There's no place like S34° 03.168' E018° 49.342'
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
