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 ?
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)