I have a got a date column in database CREATION_DATE which is with timestamp.
I want to create a new column (CREATION_DATE_AGGR) in RPD without timestamp.
Business wants to see both the columns.
They can aggregate date based on new column CREATION_DATE_AGGR.
And they want to refer to CREATION_DATE for any detailed analysis.
Can anyone please let me know how can I create logical column CREATION_DATE_AGGR from CREATION_DATE with only date?
In answers data format choose one as with timestamp and other one as just date and then save then as system wide.
or else cast to date might work