Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ganeshK
Contributor
Contributor
‎2021-07-15 02:15 PM

Date format with 6 digits nano seconds

Hi,

I have input string "2021-07-14-19.55.49.107000" , I just want to convert from string to Date datatype.

Currently i tried with tMap component using TalendDate.parseDate("yyyy-MM-dd-HH.mm.ss.SSSSSS", "

2021-07-14-19.55.49.107000"

) 

Output is : 2021-07-14-19.57.36.000000

Expected Output:

2021-07-14-19.55.49.107000

Please help me on this issue.

Thanks in advance.

Regards,

Ganesh.R

Labels (2)
Labels
263 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2021-07-16 02:50 AM

Hello,

Here is a KB article about: https://community.talend.com/s/article/How-to-fetch-data-that-uses-the-date-format-in-microseconds-y...

Hope it helps.

Best regards

Sabrina

263 Views
0 Likes