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
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

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