Get Data in UTC Format

[abdullah123456789]

When i tried to export data in csv format i get data in local time of my computer but I need to get time information in UTC format for csv file extension. Could you help me about this situation?

I also attached example file at bottom.

i am sharing the SQL query i am using.

SELECT
FORMATVALUE( "CurrentTime" USING 'yyyy-MM-dd HH:mm:SS') as "~ Record Time", "WLM_ID","CurrentValueAsReal", "CurrentQuality"

FROM
CDBPoint

WHERE
"WLM_ID" <> ''

[CraigEl]

What Product does this question relate to?

[abdullah123456789]

I get this problem in Geo SCADA Expert 2021.

[AndrewScott]

You've not specified how you're doing the export, but I assume you're using the SQL export driver. rather than a custom application or Microsoft Excel.

The SQL export driver doesn't allow the time zone to be specified. For 'raw' times it outputs them in UTC, for times converted to strings the query processor converts them to local time during the conversion, and then returns the resulting text to the SQL export driver.

The following query should return the times in UTC but using the default formatting:

SELECT
    "CurrentTime", "WLM_ID", "CurrentValueAsReal", "CurrentQuality"
FROM
    CDBPoint
WHERE
    "WLM_ID" <> ''

[abdullah123456789]

Thanks for the help. It worked.

Additionally, i am getting the data as in this screenshot,

but i need to get the data as in this screenshot.

In summary i need to get data as YYYY-MM-DD HH:MM:SS

Time format should be in UTC, date format should be as in the second screenshot

[AndrewScott]

The format of values in the CSV file is determined by the locale that is specified for the SQL export:

Specify the Locale that Geo SCADA Expert is to Apply to the Exported SQL Query Result 

I think Polish and Swedish both uses a date-time format of "yyyy-MM-dd HH:mm:ss.SSS"

[abdullah123456789]

It worked. Thanks for your support.