472,126 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,126 software developers and data experts.

MSSQL Datetime snafu

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. Also I've tried doing

Expand|Select|Wrap|Line Numbers
  1. SP_DEFAULTLANGUAGE @loginame = username, @LANGUAGE = english
and even after this I still get the following results:

-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 any help, I'm totally stumped! -Adam
Apr 22 '09 #1
2 2570
2,878 Expert 2GB
Here, read this...

--- CK
Apr 24 '09 #2
2,878 Expert 2GB
Here are more reading....stuff..

Searching Dates

--- CK
Apr 24 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

14 posts views Thread by Kukurydz | last post: by
2 posts views Thread by Ian Hinson | last post: by
7 posts views Thread by .Net Sports | last post: by
1 post views Thread by thomas kern | last post: by
4 posts views Thread by Robert Dobson | last post: by
2 posts views Thread by jblankenburg | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.