[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

.Net Framework 2.0 Datetime conversion from character string

Posted on 2007-10-09
3
Medium Priority
?
222 Views
Last Modified: 2013-11-07
Hi Experts & Guru's,

I've have a problem with .Net Framework 2.0 and SQL Express 2005.

When installing an application on a non english PC ...i get a .Net Framework error.

Conversion failed when converting datetime from character string

Please could you Guru's assist me...Thanks


0
Comment
Question by:ncomper
2 Comments
 
LVL 5

Author Comment

by:ncomper
ID: 20043155
I have uploaded a copy fo the error file
http://www.quickfileupload.com/754error.jpg

We are rolling out a global application and I am told that this is an issue where it does not like the Date / Time format.  I have also been told that this is a common problem and could possible be solved by a Globalisation fix in .net to help the colation of the DB.

Can anyone help realy Desperate :)
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 1500 total points
ID: 20043194
The "best" way to deal with dates is to use the unambiguous Year-Month-Day (YMD) format when specifying dates, and you won't have any problems parsing a string into a date.

Bob
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

830 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