System.Convert.ToDateTime issue

[Tim Cowan]

Hi

I am using System.Convert.ToDateTime to convert a date from a DB to datetime
type. The only trouble is it works one way on my local computer and another
way on our production server.

Being located in Canada I get: 4/13/2005 for April 13 2005
Our production server also located in Canada about 40mins away: 13/4/2005
for April 13 2005.

The DateTime conversion fails because it does not recognise the 13th month!
Where on the server do I have to change the date time format/regional
settings.

Another twist is that I don't have hands on, only through Terminal Services
so I have to get the hosting company to change it.

I had them change it to Canada for Regional settings and the date time
format for Canada.

It is still formatting wrong. Is there anywhere else that we have to change
it? Do I need to reboot the server?

Tim Cowan

 

[Angrez Singh]

Hi,

Not sure but just try to get the date in some specific format. I mean
don;t just do System.Convert.ToDateTime. After getting DateTime use
DateTime.ToString() method to format date explicitly in any form you
want.

For more info:
http://msdn.microsoft.com/library/d...tml/frlrfSystemDateTimeClassToStringTopic.asp

HTH,
Regards,
Angrez