Retrieved date from MsSQL in French

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?
previewservicesAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
armchair_scouseConnect With a Mentor Commented:
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
 
Ray PaseurCommented:
0
All Courses

From novice to tech pro — start learning today.