Hi Friends,
I want to set the default date format as dd-mon-yyyy. How do i do this in
mysql.
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.
regards
anandkl
