From: Ananda Kumar
Date: October 13 2005 12:40pm
Subject: setting date format
List-Archive: http://lists.mysql.com/mysql/190339
Message-Id: <829b199c0510130540m4a19dff1ya7b9be466837e94a@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_3422_1019821.1129207238160"

------=_Part_3422_1019821.1129207238160
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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=3D'%d-%m-%y';. The command executed an=
d
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

------=_Part_3422_1019821.1129207238160--