topic Parse char to timestamp in Talend Studio

Parse char to timestamp

Anonymous — Sat, 16 Nov 2024 02:39:53 GMT

Hi,

I have a table column with char data type and below is the value. Now I need to convert this to a date data type. I am trying to use TalendDate.parseDate and TalendDate.formatDate combination to achieve this. Can you please help how to get this done? Appreciate the help!

Source Value - 2020-04-12-23.43.00.013342

Code trying to use:

TalendDate.parseDate("yyyy-MM-dd-HH.mm.ss.ssssss",row7.OPPORTUNITYID.trim())

Re: Parse char to timestamp

manodwhb — Fri, 17 Apr 2020 00:37:45 GMT

how are you getting as char? Really not understand and the below expression is to convert string to date.

TalendDate.parseDate("yyyy-MM-dd-HH.mm.ss.ssssss",row7.OPPORTUNITYID.trim())

Re: Parse char to timestamp

Anonymous — Fri, 17 Apr 2020 00:48:29 GMT

Hi Manohar,

let me put it this way.

i have a column as char data type with value "2020-04-12-23.43.00.013342" on it.

Now i need to convert this to DATE datatype by keeping the same format of the value.

please let me know how this can be done.

Re: Parse char to timestamp

manodwhb — Fri, 17 Apr 2020 00:51:15 GMT

First convert char to sting and then you try to use expression, which you have.

Re: Parse char to timestamp

Anonymous — Fri, 17 Apr 2020 01:38:25 GMT

I stand corrected that my source format is actually string not char. I used below command.

source - 2020-04-12-23.43.00.013342

TalendDate.parseDateInUTC("yyyy-MM-dd-HH.mm.ss.ssssss",row7.OPPORTUNITYID)

output - 2020-04-12-23.25.22.000022

tMap output definition.

i am not sure why mm.ss.ssssss part is getting changed.

Re: Parse char to timestamp

ganeshK — Thu, 06 May 2021 06:49:40 GMT

Hi Prabav, I am also facing same issue mm.ss.ssssss part is getting changed. Have you resolved this issue?

Re: Parse char to timestamp

gjeremy1617088143 — Thu, 06 May 2021 06:53:46 GMT

Hi , the java Time class don't support nanosecond.

the max you can use is for millisecond.

You can use the LocalDateTime class instead

Send me Love and Kudos