Re: Changing MySQL Date Format
| From: | Torsten Roehr | Date: | Thu, 12 Aug 2004 16:11:53 +0000 |
| Subject: | Re: Changing MySQL Date Format | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-193594@lists.php.net to get a copy of this message | ||
"Harlequin" <michael.mason@arraspeople.co.uk> wrote in message
news:20040812122500.89710.qmail@pb1.pair.com...
> I'm using a hell of a lot of dates in my databases and wondered if it was
> possible to change the date format in my databases from 0000-00-00 to:
> 00-00-0000...?
This would make ordering by date impossible - do you really want this? You
should put formatting issues into your application and rely on the ISO
format in your database.
Regardsm Torsten Roehr
>
> Has anyone else managed to do this or use any workarounds I could use
> perhaps...?
>
> I'm just getting a little hacked of having to explode the damn things
every
> time I use them.
>
> --
> -----------------------------
> Michael Mason
> Arras People
> www.arraspeople.co.uk
> -----------------------------