List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:October 13 2005 12:56pm
Subject:Re: setting date format
View as plain text  
Ananda Kumar wrote:
> Hi Friends,
> I want to set the default date format as dd-mon-yyyy. 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. 'date_format' is not listed there.

Also
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
states:
"# date_format
This variable is not implemented.
# datetime_format
This variable is not implemented."

It's probably listed there for future use.

Kind regards, Jigal.
Thread
setting date formatAnanda Kumar13 Oct
  • Re: setting date formatJigal van Hemert13 Oct