How to Solve Datetime Problem in IIS

Pramod Lawate

13y9.4k.NET

hi guys i having a problem in Datetime function

i am using

Visual Studio 2008

framework 3.5

12/09/2012 12:18:34 PM this is the exact format datetime stored in my database and i am just fire a query and get the date in my datatable like

lblDatetime.Text = System.Convert.ToString(dt.Rows[0]["Date_Time"]);

it is working well in while developing the application but once i deploy in IIS i am getting the error like string was not recognized as a valid datetime

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Balu Mate11y ago
DUDE can u tell me the how to use Datetime.parce.Extract() function without converting the string for oracle database in iis7
Iftikar Hussain13y ago
you can use Convert.Todatetime untill if you are sure that your datetime value is in correct format. Just recycle your application pool and check
Pramod Lawate13y ago
Dude our IT person configure local machine and sever as same regional datetime format.

i googled on web they said convert to datetime is not working on IIS. instedof use datetime.parceExtract() function.
Iftikar Hussain13y ago
in that IBM server weather the datetime setting is same as with your sql server?
Pramod Lawate13y ago
Iftikar we used our own IBM Server for Monitoring Data to Client. and also i checked in control panel my regional setting

short date = dd/MM/yyyy
long date = dddd, MMMM dd, yyyy

short time = h:mm tt
Long time = h:mm:ss tt
Iftikar Hussain13y ago
Hi,
Have you deployed your application in different timezone server or in your local PC?

Regards,
Iftikar