[PHP] Changing MySQL Date Format

2004-08-12 Thread Harlequin
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

RE: [PHP] Changing MySQL Date Format

2004-08-12 Thread Jay Blanchard
[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 -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

Re: [PHP] Changing MySQL Date Format

2004-08-12 Thread Stephan Fiedler
Hi Harlequin, Harlequin wrote: [...] I'm just getting a little hacked of having to explode the damn things every time I use them. You EXPLODE them?? When you want it human readable why not simply preg_replace(/(\d{4})-(\d{2})-(\d{2})/, $3-$2-$1 [*], $input); it? or preg_replace it to something

Re: [PHP] Changing MySQL Date Format

2004-08-12 Thread Brent Clements
: [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 -00-00 to: 00-00-...? Has anyone else managed to do this or use any workarounds I could use perhaps...? I'm just

Re: [PHP] Changing MySQL Date Format

2004-08-12 Thread John Holmes
Stephan Fiedler wrote: Hi Harlequin, Harlequin wrote: [...] I'm just getting a little hacked of having to explode the damn things every time I use them. You EXPLODE them?? When you want it human readable why not simply preg_replace(/(\d{4})-(\d{2})-(\d{2})/, $3-$2-$1 [*], $input); it? or