[PHP] Re: Changing MySQL Date Format

2004-08-12 Thread David Robley
On Thu, 12 Aug 2004 20:06, Harlequin wrote:

 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 -00-00 to:
 00-00-...?
 
 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.
 

Why do you care how mysql stores the dates when you have DATE_FORMAT and all
the other you-beaut date functions to massage the data to your needs?

-- 
David Robley

I parked my hard disk and now I can't find it!

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: Changing MySQL Date Format

2004-08-12 Thread Torsten Roehr

Harlequin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 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 -00-00 to:
 00-00-...?

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
 -

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php