troubleshooting Question

Problems inserting date in table with different locale other than en-US

Avatar of rmmarsh
rmmarshFlag for United States of America asked on
Microsoft SQL Server 2005
3 Comments1 Solution168 ViewsLast Modified:
I have a DateTime in the format:  20/07/2007 08:14:18

I am trying to insert that into a table column whose format is DateTime (the locale is en-GB)...

I have two questions:
1.  when I installed SQL Server Express 2005 on my Win 2000 Pro machine (running in a virtual machine), whose locale was en-GB, did I have to do anything during the install to tell SQL Server of that locale?
2.  how do I get the date above into the column without getting a conversion error?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros