Date Format Problem
-
Hi, I finished developing the .net windows application.problem is in date format.the application developed with the date format of "MM/dd/yyyy" with this appication working fine.but now i want to change the dateformat to "dd/MM/yyyy" by setting this format im getting the folling error "String was not regcognized as valid date format". i have to change the format in one place so that it gets effect in all over the application. i have tried withe the below code.but its not working. CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone(); culture.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy"; culture.DateTimeFormat.LongTimePattern = ""; System.Threading.Thread.CurrentThread.CurrentCulture = culture; Regards Kanna
-
Hi, I finished developing the .net windows application.problem is in date format.the application developed with the date format of "MM/dd/yyyy" with this appication working fine.but now i want to change the dateformat to "dd/MM/yyyy" by setting this format im getting the folling error "String was not regcognized as valid date format". i have to change the format in one place so that it gets effect in all over the application. i have tried withe the below code.but its not working. CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone(); culture.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy"; culture.DateTimeFormat.LongTimePattern = ""; System.Threading.Thread.CurrentThread.CurrentCulture = culture; Regards Kanna
I just wrote a quickie C# WinForms application duplicating your code, and it works fine. Ditto with a console app. Is this an ASP.NET app you are working on?
-
I just wrote a quickie C# WinForms application duplicating your code, and it works fine. Ditto with a console app. Is this an ASP.NET app you are working on?
No Yaar,that code will convert to desire format.but while inserting the record im geeting the error.string was not recognized as valid datetime. for this what i have to do.
-
No Yaar,that code will convert to desire format.but while inserting the record im geeting the error.string was not recognized as valid datetime. for this what i have to do.
what sort of database are you using - what is the table/column definition ? I know Oracle has a function like from_date('18052010', 'ddmmyyyy') type of thing (that may not be exact), that works if the column is defined as date or datetime - ie you can use the 'ddmmyyyy' to tell Oracle how to parse the first argument, in this case 18th 05 (May) in 2010, Non American format 'g'
-
No Yaar,that code will convert to desire format.but while inserting the record im geeting the error.string was not recognized as valid datetime. for this what i have to do.
Oh, it's a database insert issue. What database are you using? MySQL? If MySQL, try yyyy-MM-dd.
-
Oh, it's a database insert issue. What database are you using? MySQL? If MySQL, try yyyy-MM-dd.
IM using MS Sql Server 2005 db.
-
Hi, I finished developing the .net windows application.problem is in date format.the application developed with the date format of "MM/dd/yyyy" with this appication working fine.but now i want to change the dateformat to "dd/MM/yyyy" by setting this format im getting the folling error "String was not regcognized as valid date format". i have to change the format in one place so that it gets effect in all over the application. i have tried withe the below code.but its not working. CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone(); culture.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy"; culture.DateTimeFormat.LongTimePattern = ""; System.Threading.Thread.CurrentThread.CurrentCulture = culture; Regards Kanna
You need to provide more and accurate information. The error message you have shown is unknown to Google, except for your own message at eggheadcafe; so it must be something your app is generating itself. Check your code for it! Use whatever means you're accustomed to to determine which line is generating the error; then study that method, maybe show it here (inside PRE tags!!!!!!!!!!!!!!!!!!!). If a database is involved, tell is which one; and the field format; and the code that reads/writes the field. Are you using SQLParameter? FWIW: Here[^] us some overall information on datetimes. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
-
You need to provide more and accurate information. The error message you have shown is unknown to Google, except for your own message at eggheadcafe; so it must be something your app is generating itself. Check your code for it! Use whatever means you're accustomed to to determine which line is generating the error; then study that method, maybe show it here (inside PRE tags!!!!!!!!!!!!!!!!!!!). If a database is involved, tell is which one; and the field format; and the code that reads/writes the field. Are you using SQLParameter? FWIW: Here[^] us some overall information on datetimes. :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
yes.i agree. the exact message is "String was not recognized as a valid DateTime"
-
IM using MS Sql Server 2005 db.
I think we've established that you're getting an Microsoft SQL Server syntax error on an insert, right? Did you check the actual insert statement string in the debugger? That date format is valid for MS SQL, and it's fine with a date-only without time for a DATETIME. At this point without more info (some code), my best guess would be the usual suspects: columns in INSERT statement out of order or a need to quote the fields. Try backquote.