Timestamp value not populated correctly using Dynamic Schema

IamHulk — Sat, 16 Nov 2024 00:14:45 GMT

Hi ,

I am trying to extract the data from oracle data base to csv file by using the talend studio 7.3 version. I am extracting the data as dynamically by defining the schema as dynamic in toracleinput component. I am facing isuue for timestamp column. not able to bring the micro seconds and nano seconds from source.

Example :-

oracle table have data like

--------------------------------------------

| create_time |

--------------------------------------------

| 27-02-2014 15:03:09.789 |

| 27-02-2014 15:03:09.000923 |

| 27-02-2014 15:03:09.574098 |

| 27-02-2014 15:03:09.789000549 |

--------------------------------------------

in talend dynamic schema i am trying with different options

option-1 : with out date

pattern

its giving the below result

--------------------------------------------

| create_time |

--------------------------------------------

| 27-02-2014 15:03:09 |

--------------------------------------------

option-2 : with date pattern "dd-MM-yyyy hh:mm:ss.SSS"

--------------------------------------------

| create_time |

--------------------------------------------

| 27-02-2014 15:03:09.789 |

| 27-02-2014 15:03:09.000 |

| 27-02-2014 15:03:09.574 |

| 27-02-2014 15:03:09.789 |

--------------------------------------------

option-3: with date pattern "dd-MM-yyyy hh:mm:ss.SSSSSS"

--------------------------------------------

| create_time |

--------------------------------------------

| 27-02-2014 15:03:09.000789 |

| 27-02-2014 15:03:09.000923 |

| 27-02-2014 15:03:09.574098 |

| 27-02-2014 15:03:09.789000 |

--------------------------------------------

option-4 with date pattern "dd-MM-yyyy hh:mm:ss.SSSSSSSSS"

--------------------------------------------

| create_time |

--------------------------------------------

| 27-02-2014 15:03:09.000000789 |

| 27-02-2014 15:03:09.000000923 |

| 27-02-2014 15:03:09.000574098 |

| 27-02-2014 15:03:09.789000549 |

--------------------------------------------

is there any possible way we can get the full timestamp value without changing the data .in talend my expected output is as below

--------------------------------------------

| create_time |

--------------------------------------------

| 27-02-2014 15:03:09.789 |

| 27-02-2014 15:03:09.000923 |

| 27-02-2014 15:03:09.574098 |

| 27-02-2014 15:03:09.789000549 |

--------------------------------------------

can any one help to get like this talend studio

Re: Timestamp value not populated correctly using Dynamic Schema

gjeremy1617088143 — Fri, 16 Apr 2021 14:23:32 GMT

Hi , could you try this pattern ? : "yyyy-MM-dd hh:mm:ss.fffffffff

Send me Love and Kudos

Re: Timestamp value not populated correctly using Dynamic Schema

IamHulk — Fri, 16 Apr 2021 18:35:39 GMT

"yyyy-MM-dd hh:mm:ss.fffffffff" is a illegal pattern in talend.

Re: Timestamp value not populated correctly using Dynamic Schema

gjeremy1617088143 — Sat, 17 Apr 2021 10:07:37 GMT

Hi after few search, it seem java.util.date class use for date don’t support nanosecond. See if you can extract your data in an other format than date . And you can parse it via other java class in a routine . Send me love and kudos

topic Re: Timestamp value not populated correctly using Dynamic Schema in Talend Studio

Timestamp value not populated correctly using Dynamic Schema

Re: Timestamp value not populated correctly using Dynamic Schema

Re: Timestamp value not populated correctly using Dynamic Schema

Re: Timestamp value not populated correctly using Dynamic Schema