Converting Datetime to varchar along with removal of timestamp in physical layer

You can do this way by going to physcial layer of RPD and go to the table the date column is coming from
1) go to properties of the table
2) go to general tab and change the table type to SQL
3) Write the SQL by selecting required columns from that table including this date column i.e.
select x,y,trunc(date_column) from table_name

This way the timestamp will be gone.'

Until Next Post... :)