
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oracle timestamp - milliseconds not stored
Hi,
Discussion started on https://community.talend.com/t5/Design-and-Development/Load-DATE-type-into-an-Oracle-TIMESTAMP-colum... but I have the same issue and can't find a solution. Can't store the milliseconds in a timestamp target colum in Oracle, but when I store it in a varchar2 column I can see the milliseconds. So it looks like that the datatype "Date" with pattern "yyyy-MM-dd HH:mm:ss.SSS" is losing the SSS part.
Talend version: 6.4.1
Oracle: 11gR2
Database Oracle_target
I select an Oracle timestamp source column but I convert into a string using SQL:
to_char(le.STARTTIME ,'yyyy-MM-dd HH24:MI:ss.FF3') AS SERVICE_STARTTIME
Example: '2017-12-13 15:25:16.656'
Input
In mapping I do the following:
mapping
mapping datatype
Target datatype
Target Adv settings
Result when running job:
Target Result
As you can see, when stored as a string I can see the milliseconds but when this is a timestamp it's lost. Any idea's on how to resolve this?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Found the reason, in target I must specify 'TIMESTAMP' as DB Type, by default you will have 'DATE'
timestamp
Working now

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Some extra info, this is what I see in the code:
code

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Found the reason, in target I must specify 'TIMESTAMP' as DB Type, by default you will have 'DATE'
timestamp
Working now
