setting date format

2005-10-13 Thread Ananda Kumar
Hi Friends, I want to set the default date format as dd-mon-. 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

Re: setting date format

2005-10-13 Thread Jigal van Hemert
Ananda Kumar wrote: Hi Friends, I want to set the default date format as dd-mon-. How do i do this in mysql. The short answer: not. http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html lists the variables you can change by the SET GLOBAL or SET SESSION command.