FYI - date change can be made by
CLIENT:
mysql> set date_format = '%m-%d-%Y';
**OR**
mysql> set date_format = '%d-%m-%Y';
SERVER:
mysql> set global variable date_format = '%m-%d-%Y';
**OR**
mysql> set global variable date_format = '%d-%m-%Y';
Don't know if it goes past a shutdown and restart, but it will work for
now... =)
J.R.
-----Original Message-----
From: Mark Mchugh [mailto:mark...@yahoo.com]
Sent: Thursday, March 24, 2005 10:27 AM
To: mysql list
Subject: changing default date format on server
hi,
How can i change the default date field to european format, i.e. dd/mm/yyyy
?
thanks
6 messages in com.mysql.lists.win32RE: changing default date format on s...