This content has been marked as final. Show 3 replies
Plz can someone reply on this?
Please try to use this function. it is good if we have sample data for both columns.Please provide if you have issues using following function
Evaluate( 'to_date(%1,%2)',Evaluate( 'TO_CHAR(%1)' as char,20090101) , 'yyyymmdd')
This should work on Physical layer, use fx icon or write it manually
cast(datetimeCol as date) =cast(timestampCol as date)
If helps mark