Solved

Retrieved date from MsSQL in French

Posted on 2012-03-20
3
260 Views
Last Modified: 2012-06-27
Hello,

When I retrieve a datetime field from MsSQL, it appears in French e.g. 20/mars/2012 9:03. Anyone know how to sort this out. I have tried the code date_default_timezone_set('GMT'); but didn't work. Any suggestions?
0
Comment
Question by:previewservices
3 Comments
 
LVL 9

Accepted Solution

by:
armchair_scouse earned 500 total points
ID: 37741533
According to the web, to change the server language to British English, you'd use

EXEC sp_configure 'default language', 23
RECONFIGURE

Run to verify: SELECT @@language, @@langid

To change the language of a particular login to britsh english, use
EXEC sp_defaultlanguage 'username', 'british'

Alternatively, handle dates in the YYYY-MM-DD format, which I believe is the ISO standard, and therefore you'd have no problems with whatever language setting your scripts run under.
0
 
LVL 30

Expert Comment

by:IanTh
ID: 37741536
0
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 37741736
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question