List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:October 13 2005 12:40pm
Subject:setting date format
View as plain text  
Hi Friends,
I want to set the default date format as dd-mon-yyyy. How do i do this in
I tried this, set global date_format='%d-%m-%y';. The command executed and
when i did "show variable" it show the new format.
But when i tried the below test, i got wrong results. Can u please help.

mysql> create table mytest(doj date);
Query OK, 0 rows affected (0.05 sec)

mysql> insert into mytest values('21-01-2005');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * from mytest;
| doj |
| 0000-00-00 |

   please help.

setting date formatAnanda Kumar13 Oct
  • Re: setting date formatJigal van Hemert13 Oct