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)