On Wednesday 11 April 2007 19:05, Hans du Plooy wrote:
> On Wed, April 11, 2007 17:54, Adam Tauno Williams wrote:
> >> I have records with the date in DD-MM-YYYY, but mysql wants them in
> >> YYYY-MM-DD. Is there anyway of changing Mysql's format?
> >
> > I don't EVER use MySQL; but with most databases this is just a matter
> >of changing your locale. Should be doable via an environment variable
> >(client side) or a parameter in your DSN/connection-string.
I don't think this is what I want to do. I only want to change it on one
database. The others are fine. If I can't change mysql, is there a way to
reverse the date in the file before I put it in mysql?
> Please don't make a statement like that without explaining why. I can
> think of a few reasons, but I don't know everything and I'm sure more
> people on this list would now why.
>
> Hans
Personally I use mysql because many many years ago I learned Dbase 3+, when I
changed to Linux I found that mysql was almost the same as Dbase. So it was
easy to learn. There might be better databases, but mysql is fine for every
thing I do.
Thanks,
JIM
--
Jim Hatridge
Linux User #88484
Ebay ID: WartHogBulletin
------------------------------------------------------
WartHog Bulletin
Info about new German Stamps
http://www.WartHogBulletin.de
Many Enemies -- Much Honor!
Anti-US Propaganda stamp collection
http://www.manyenemies-muchhonor.info
An American in Bavaria
http://www.gaubodengalerie.de
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
