Member Avatar for akronymn

I have an mssql database that I need to migrate to mysql. For some reason though any queries to any columns of type datetime are returned in French in the following format:

7/avr/2004 14:00

This also includes all the text of an SQL dump which not surprisingly makes mysql unable to read the dump from the MSSQL db. I've checked that my windows regional setting is set to English. I'm at a loss as to why this is happening or how to fix it. I just need them to be in mdy h:m:s format. One interesting thing I've noticed also is that if I look at the tables via the MSSQL Server Manager the dates are displayed as mdy h:m:s Thanks! -adam

  • 3 Contributors
  • 5 Replies
  • 286 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by Ramy Mahrous

Recommended Answers

All 5 Replies

Member Avatar for Ramy Mahrous

What's the tool you use to migrate?

Member Avatar for akronymn

I'm using a third party app called sqlDump.

Member Avatar for Ramy Mahrous

As SQL shows date fields in correct format (like you want) so the problem in your third party that maps data types between SQL Server and MySQL. Check if you can configure mapping processing to enforce your third party to convert in that format do or check the technical support of the product .

Member Avatar for mandm_zoom

How was this issue resolved? can you please tell me

Member Avatar for Ramy Mahrous

We don't hear anything from them.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.