MSSQL datetime format

[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

 

[gmmastros]

the problem is the language of the login. Read this.

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[akronymn]

So I tried:

SP_DEFAULTLANGUAGE @loginame = username, @LANGUAGE = english

in MSSQL Server Manager, which said the command was succesful. However I'm still getting the same results. More specifically:

-If I connect via PHP and then query the database I get the French dates.
-When I run the sqlDump program it connects to the database and all the dates in the dump are in the French format.
-If I run SQL Server Manager and do a query with its query editor I get back the dates in the expected 2004-03-10 10:45:00 format.

Thanks for looking into this, I'm stumped and appreciate all the help I can get! -Adam

 

[gmmastros]

Did you log out and log back in after changing the default language?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[akronymn]

Yep, I disconnected all connections and restarted the SQL server too. Same results across the board.