Trying to use DateTimeConverter to conver Oracle Date to PostgreSQL timestampz. Have tried multiple formats.
Value of attribute 'start_date' could not be converted to type 'timestamptz'. Feature will be logged and skipped
Question
Oracle Date to PostgreSQL TIMESTAMPZ
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+51- Evangelist
Are you reading data from Oracle? If it's coming from the date field in Oracle it will already be in an FME format irrespective of how it is displayed in Oracle so you shouldn't need to do this conversion
+7- Contributor
Are you reading data from Oracle? If it's coming from the date field in Oracle it will already be in an FME format irrespective of how it is displayed in Oracle so you shouldn't need to do this conversion
Correct from Oracle Date to PostgrSQL timestampz. I removed the DateTimeConverter, this is the result:
Value of attribute 'start_date' could not be converted to type 'timestamptz'. Feature will be logged and skipped
+7- Contributor
Are you reading data from Oracle? If it's coming from the date field in Oracle it will already be in an FME format irrespective of how it is displayed in Oracle so you shouldn't need to do this conversion
I changed the target postgresql table to use timstamp instead of timestamptz. Same error.
Value of attribute 'start_date' could not be converted to type 'timestamp'. Feature will be logged and skipped
@jbradfor as @ebygomm mentions - if your source data is Oracle with a data type timedate, then FME will have converted the Oralce date field into the FME data format. So you shouldn't need the TimeDateConverter at all. To check that FME is reading and interpreting your Oracle date field correctly, add an Inspector after the Oracle reader feature type and check the date field. It should have the standard FME date format.
+7- Contributor
I modified the postgresql start_date to timestamp.
Then I added this dateconverter logic.
SUCCESS!
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.