Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
| 27-02-2014 15:03:09 |
| 27-02-2014 15:03:09 |
| 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
Hi , could you try this pattern ? : "yyyy-MM-dd hh:mm:ss.fffffffff
"
Send me Love and Kudos
"yyyy-MM-dd hh:mm:ss.fffffffff" is a illegal pattern in talend.
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