Six Stars

Talend Date

I am getting date value from the DB and assigned to context variable 

 

But when i try to use in the subsequent query it takes values as below  .. How do i eliminate those timestamp values ?

 

2018-01-22 00:00:00.0

2 REPLIES
Thirteen Stars

Re: Talend Date

The Java Date class will automatically store a timestamp. You can't get rid of it and shouldn't want to. What is a day without an hour? What is an hour without a minute? What is a minute without a second? Take a look here (https://docs.oracle.com/javase/8/docs/api/java/util/Date.html). What exactly is your problem with the time element to this date? Are you trying to write a query using a date without the timestamp? If so, you need to look at formatting the date. This page might help you with that (https://help.talend.com/reader/~R4Lk_SlELw9a8pKBKTm9A/JFWl8U3lEbhWZEFAUtYvMw)

Rilhia Solutions
Six Stars

Re: Talend Date

I am able to implement using to_date function in the query