Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange, strange things
Message
From
24/10/2013 18:50:57
 
 
To
24/10/2013 18:35:26
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01586334
Message ID:
01586343
Views:
30
>>
>> ssprocessds.hhpickup.Rows.Clear();
>> ssprocessds.ReadXml(f.FullName);
>>
>>
>>At the client site, when I read 2013-10-24T00:00:00-04:00 from the .xml file ( I don't know how to show the xmlhere)
>>the result in the datetime column of the datatable was 2013-10-23:09:00.
>>
>>It worked fine on my site.
>>I was testing at about 1PM ET.
>>I noticed that time on the client machine was 3 hrs behind me because the Time Zone was Pacific.
>>I changed the time zone on the client machine and got the correct date when reading the xml.
>>Does anyone know why a time zone should push a date back a day in the middle of the day?
>>Also, why would readxml mess with a date at all?
>
>If the time in the column was 9PM, then it would be correct, as the time was adjusted to local time. If it was 9AM, then something else is wrong.
>
>Assuming it was 9PM and adjusted to local time, you have a couple of options:
>1) If you can control the XML that is written either a) write and read the UTC date instead of the local date, or b) leave off the time offset off of the time.
>2) If you can't control the XML, use TimeZoneInfo.ConvertTime (http://msdn.microsoft.com/en-us/library/system.timezoneinfo.converttime.aspx) to change the time to the timezone it originated from.

Thanks, Rob.

I'll take a look
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform