Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange, strange things
Message
De
24/10/2013 18:50:57
 
 
À
24/10/2013 18:35:26
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01586334
Message ID:
01586343
Vues:
29
>>
>> 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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform