You can translate the question and the replies:

Load a Date Column using Scheduler

Hi , We tried creating a derived view which has a Date Type column and we are trying to load it to the database table which has a date type column in Oracle. Whenever we execute the job to load the data from Derived view to the table , we get the below error saying : Throwing exception java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

1 Answer

Hi, I could load the data type column through scheduler to Oracle target table without any error. I also loaded timestamp column from source to target and it loaded without issue. I referred to the [General Structure of a Job](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/general_structure_of_a_job) section of the Scheduler Administration Guide for job creation. If I don’t want the timestamp at all, I’d also take a look at the [Schema of the Base View](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/viewing_the_schema_of_a_base_view/viewing_the_schema_of_a_base_view#viewing-the-schema-of-a-base-view) and edit the field type. Even though it has the field type date, if you click the edit (pencil) icon next to the drop-down, you’ll be able to choose whether this field should be represented as a DATE, TIME, or full TIMESTAMP. Hope this helps!
Denodo Team
26-06-2019 06:50:10 -0400
You must sign in to add an answer. If you do not have an account, you can register here