Oracle Timestamp type convert to Date

Good Afternoon.

I am using ADS version 18.0.18-5 with an Oracle database version

I am trying to convert a Timestamp field to a Date formatted as MM/DD/YYYY without the Time portion. I have tried the following.

Field name is ADDED_TS

SUBSTR(ADDED_TS, 1, 9)    ----------------------------------------------------Shows as 04-JAN-18

TO_CHAR(ADDED_TS, 'MM/DD/YYYY') -------------------------------------Shows as 01/04/2018 in Character format

TO_DATE(to_char(ADDED_TS, 'MM/DD/YYYY'), 'MM/DD/YYYY') --- Shows as 1/4/2018 12:00:00 AM

Appreciate any assistance.



No Data
Reply Children
No Data