Bug #28402 date format
Submitted: 13 May 2007 17:21 Modified: 14 May 2007 9:03
Reporter: sandeep singh Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[13 May 2007 17:21] sandeep singh 
Description:
hi dear can this possible to insert data in date field in table in dd-mm-yyyy
because there's a problem we have software that is off line we are attaching that off line software to online my sql in that we have old format of date is dd-mm-yyyy
please help me i am really helpless.
thanks.

How to repeat:
hi dear can this possible to insert data in date field in table in dd-mm-yyyy
because there's a problem we have software that is off line we are attaching that off line software to online my sql in that we have old format of date is dd-mm-yyyy
please help me i am really helpless.
thanks.
[14 May 2007 9:03] Sveta Smirnova 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.
[14 May 2007 9:04] Valeriy Kravchuk 
Use explicit STR_TO_DATE(str,format) calls. Read the manual, http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_get-format, about the details.