Re: Changing MySQL Date Format

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 machine-readable and for the output use strftime? or even simpler: select unixtimestamp(mytime) and strftime later? Stephan [*] if you want the month leading it is $2-$3-$1...