.Net Framework 2.0 Datetime conversion from character string

Posted on 2007-10-09
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

Question by:ncomper
    LVL 5

    Author Comment

    I have uploaded a copy fo the error file

    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 :)
    LVL 96

    Accepted Solution

    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.


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now