+7I'm trying to convert datetime values in ISO format to FME, because PostgreSQL database refuses to write that value as "timestampz". I have tried to both autodect and %Y-%m-%dT%H:%M:%S$
The preview show correctly the conversion:
But the ouptup stays the same:
Any hints? Thanks
Best answer by caracadrian
Something is wrong with your picture.
For me, DateTimeConverter displays selected attributes differently:
Try selecting them via the three dots menu and see if getting rid of the @Value part does the job.
If not, turn Repair Overflow on.
+62That's really odd, I tried it with the exact same date as you have and it works for me.
Could you post a new screenshot of the table view but drag the column a bit wider so we can see the entire value?
+23Something is wrong with your picture.
For me, DateTimeConverter displays selected attributes differently:
Try selecting them via the three dots menu and see if getting rid of the @Value part does the job.
If not, turn Repair Overflow on.
+7Something is wrong with your picture.
For me, DateTimeConverter displays selected attributes differently:
Try selecting them via the three dots menu and see if getting rid of the @Value part does the job.
If not, turn Repair Overflow on.
You are right, thanks. I haven't noticed it's an attribute value. I don't know why it was listed in the items list at the top, so I haven't seen the actual attribute picker. Now it works as expected. In order to fill Posgres timestampz I had to add timezone with expression
@TimeZoneSet(@Value(PlatiOd),+01:00,auto)as explained in this article.