SQL collection query - issue with timezones

mlamotte — Wed, 12 Jun 2024 13:06:33 GMT

I have an API that returns me certain items with corresponding dates.
They come in this format : 2024-06-12T13:00:00.000+02:00

When I turn them into a SQL collection, all is well.
However I get an issue when I query the SQL collection, as it suddenly returns 2024-06-12T11:00:00.000000+02:00.

I have tried formulas like to_time or strftime formulas, but I can't seem to fix this.

Preferably I would like to get an output of 2024-06-12 13:00:00.000 , without the T (not necessarily) but also without the time zone.
As I later do an upsert into a SQL database, this would need to be fixed.

For "now" I do

now.in_time_zone("Europe/Brussels").strftime("%Y-%m-%d %H:%M:%S.%L")

, and this works for my own timestamp.
But I can't seem to figure out how to fix this in the SQL collection.

topic SQL collection query - issue with timezones in Workato Pros Discussion Board

SQL collection query - issue with timezones