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.
