We have included a condition in the where clause of a logical table for a date field.
Evaluate('to_date(%1,%2)',"abcd".""."123"."Dim_SALES"."CREATED_DATE" ,'DD-MON-YY') > '01-JAN-15'
Now we have changed the data type of this field to timestamp and the above function is not working.
Can you please help me in getting this formula work for a timestamp.
got the solution.. cast( as date) worked for the timestamp.. thanks