Why not just write a simple function in php to change your date around for you? A function in a utility class perhaps?
-Brent ----- Original Message ----- From: "Jay Blanchard" <[EMAIL PROTECTED]> To: "Harlequin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 12, 2004 7:39 AM Subject: RE: [PHP] Changing MySQL Date Format [snip] 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...? 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. [/snip] The date time format is pretty standard, start here http://www.mysql.com/date You could write a date function that does your explosions for you. Or you could query the MySQL list for other solutions. (pun intended) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php