How to Solve Datetime Problem in IIS

Question

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

Balu Mate · Answer

DUDE can u tell me the how to use Datetime.parce.Extract() function without converting the string for oracle database in iis7

Iftikar Hussain · Answer

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 Lawate · Answer

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 Hussain · Answer

in that IBM server weather the datetime setting is same as with your sql server?

Pramod Lawate · Answer

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 Hussain · Answer

Hi Have you deployed your application in different timezone server or in your local PC? Regards Iftikar