Exporting timezone issue

Nathan Jones shared this problem 6 months ago
Solved

Hi,

When I create a point it shows the right local date and time, but when I export my data to CSV it shows the UTC time. Not only is it the wrong time, but more importantly it often shows the wrong date as I am in a UTC+10 timezone.

Is there any way to fix this?

Cheers, Nathan.

Comments (1)

photo
1

Good day Nathan,

I have to agree that currently used format is not ideal. Timezone information is completely lost in this case.

I've changed the format to "yyyy-MM-dd'T'HH:mm:ss.SSSZ", which result into 1969-12-31T16:00:00.000-0800 . Hopefully, it won't cause any troubles with users, who use this function for some post-process.

Menion