topic Re: Talend Date in Talend Studio

Talend Date

Karuetl — Mon, 29 Jan 2018 21:46:20 GMT

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

Re: Talend Date

Anonymous — Tue, 30 Jan 2018 00:18:36 GMT

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)

Re: Talend Date

Karuetl — Tue, 30 Jan 2018 15:28:30 GMT

I am able to implement using to_date function in the query