On Thursday, March 24, 2005 10:06, J.R. Bullington wrote: > You can change it on the command line by > > mysql> set date_format = '%m-%d-%Y'; > > However, this may be a client-only view, as I am still trying to get > the global variable to change.
[shell] #mysqld -v --help | grep date_format --date_format=name The DATE format (For future). date_format (No default value) [/shell] This has been said before, but date_format is not implemented on the server. You can set it, but I don't think it does anything. > > J.R. > > PS - Sorry it took me so long Mark, was busy and AFK > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 24, 2005 10:57 AM > To: Mark Mchugh > Cc: mysql list > Subject: Re: changing default date format on server > > Mark Mchugh <[EMAIL PROTECTED]> wrote on 03/24/2005 10:26:44 AM: > >> hi, >> How can i change the default date field to european format, i.e. >> dd/mm/yyyy ? >> >> >> thanks >> >> MArk > > However, your _client_ may have many ways to format date data for > viewing. How you change _what_you_see_ depends entirely on which tool > you are using to get data from the server and present it for viewing > or other operations. Refer to the documentation for the client you > are using for details on how to get it to show you dates in the > format you want to see. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]