WriteCSVFile service output EST instead of UTC

Forum|Forum|3 years ago
November 2, 2022
1 reply
1297 views

Hi

I have a service where i write a propertyHistory infotable to a csv file. In the UI, I can see the datetime in IST format, but I expected the timestamp on the written csv file to have UTC format. But instead, the timestamp is in EDT/EST format. Is there a method to change this conversion so that I can get the output timestamp in UTC. Since the EST/EDT vary each year the quality of the exported data has an expiration date. Please let me know your comments. @VladimirRosu_116627

V

VladimirN

24-Ruby III

Hi,

There have been similar questions before:

"How do I display local time instead of UTC?": https://community.ptc.com/t5/ThingWorx-Developers/How-do-I-display-local-time-instead-of-UTC/td-p/697252
"How to convert a UTC Date to a local time string?": https://community.ptc.com/t5/ThingWorx-Developers/How-to-convert-a-UTC-Date-to-a-local-time-string/td-p/781399
"Unable to set time at 00:00:00 hours for other timezone": https://community.ptc.com/t5/ThingWorx-Developers/Unable-to-set-time-at-00-00-00-hours-for-other-timezone/td-p/780798

A

AdarshBNair

Author

6-Contributor

Hi I have attached an image of two end results TWX GUI is QueryNamedPropertyHistory output which is in IST, and thats allright The CSV output is what I get when writing the left handside infotable to csv using WriteCSVfile service. I expected the timestamp to be writtten in UTC (5HRS AND 30 MINS BEHIND IST) But it's getting written in EST (9hrs and 30 mins behind). This is the issue I have. I want to write the data in UTC since it does not depend on Daylight saving or such variations. I am convinced that it has something to do with the way CSV Parser is interpreting the timestamp. Please let me know if some modifications to extension could fix this issue or any other solution is available.