Bug #14626 All other servers SQL processing date as string in current locale format
Submitted: 4 Nov 2005 7:54 Modified: 4 Dec 2005 9:32
Reporter: niknik niknik Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:ALL 5 OS:Any (ALL)
Assigned to: CPU Architecture:Any

[4 Nov 2005 7:54] niknik niknik
Description:
Now!
update XXX SET dt=STR_TO_DATE('30.04.2004','%d.%m.%Y') where ...;
______________________________
[mysqld][client]
date_format=%d.%m.%Y
OR
set date_format='%d.%m.%Y';
_____________________________
update go_iss SET dt='30.04.2004' where ...;

Note! All other servers SQL processing date as string in current locale format

How to repeat:
No need repeate!
Need Develop.
[4 Nov 2005 9:32] Valeriy Kravchuk
Thank you for a problem report.

Please, send the statement you performed (with the definitions and data of tables used, if any), the results you get, and describe what you expected to get or what you want us to implement instead.

Just copy and paste from mysql command line client, please.

As for "all other servers" you are simply mistaking: Oracle and Informix, for example, completely ignore your OS locale settings and use their own locales instead. Want me to provide you an example? What "all other" servers do you mean?
[5 Dec 2005 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".