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.
