Hello.
This is a frequently asked question. For example read these threads:
http://lists.mysql.com/mysql/175324
http://lists.mysql.com/mysql/177730
Shuan <[EMAIL PROTECTED]> wrote:
> Dear all,
>
> How to change the Default Date/DateTime Format of MySQL server?
> I'm us
> Is there a way how to change the date and time format accepted and
> returned by MySQL from '-mm-dd' to something different? I've seen
> several posts here telling it's impossible but they are quite old. Is
> it still true in recent MySQL versions? I can see date_format,
> datetime_format and
Hi
-mm-dd is how it is stored in the db, you have to pass the date like
that, and that is how it will be returned.
Regards
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 7