+1
I'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
View original
+25
That'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?
+20
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.
+1
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.
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.