I am unable to make data type of a column as DATE while creating view, default data type is varchar2. How can I change it to DATE column.
Below is the column definition:
TO_CHAR(DATE'1970-01-01' + ( 1465484488329 / 86400000 ), 'YYYY/MM/DD HH24:MI:SS') AS StartTime
to_char returns a
varchar. Just omit it, and you should have a
DATE'1970-01-01' + ( 1465484488329 / 86400000 )