DataSphere: DATE DataType mismatch from Oracle Source

[r_gattu]

When doing a Remote Table Import from Oracle DB into Datasphere, DATE datatype is automatically getting converted to TIMESTAMP in Datasphere. As a result I am unable to apply filter due to datatype mismatch. Any idea how to resolve the issue?

I used POST_DATE = TO_CHAR(TO_DATE('Jul 31, 2024, 0:00:00', 'Mon DD, YYYY, HH24:MI:SS'), 'DD-MON-YY' to pass the filter value  but it is not working.

Thanks

R

[fabioperel78]

Hi,

Try this:

EXTRACT(DAY FROM "POST_DATE") = EXTRACT(DAY FROM NOW()) AND
EXTRACT(YEAR FROM "POST_DATE") = EXTRACT(YEAR FROM NOW()) AND
EXTRACT(MONTH FROM "POST_DATE") = EXTRACT(MONTH FROM NOW())

Tks,

Fabio.

[r_gattu]

Thanks Fabio

I used 

TO_VARCHAR("START_TIME",'DDMMYYYY') = TO_VARCHAR(TO_DATE('Jul 31, 2024, 00:00:00', 'Mon DD, YYYY, HH24:MI:SS'), 'DDMMYYYY') 

and it is working.

thanks