Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MSSQL datetime format
Yep, I disconnected all connections and restarted the SQL server too. Same results across the board.- akronymn
- Post #5
- Forum: Microsoft SQL Server: Setup and Administration
-
MSSQL datetime format
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...- akronymn
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
MSSQL datetime format
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...- akronymn
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Setup and Administration
