Solved

Retrieved date from MsSQL in French

Posted on 2012-03-20
3
272 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 110

Expert Comment

by:Ray Paseur
ID: 37741736
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
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.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

728 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