When I select the field "DTTM_STAMP" and look at "View SQL", it has "TO_CHAR(CAST((DTTM_STAMP) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF')" (result example: 04/10/2019 3:16:59PM).
I thought this expression "TO_CHAR(CAST(DTTM_STAMP) AS TIMESTAMP),'YYYY-MM-DD HH24:MI:SS') would work but it doesn't like the ":" in the time to get "2019-04-10 15:16:59" When I change the colons to periods then it works "2019-04-10 15.16.59"
I would appreciate any help!
I thought this expression "TO_CHAR(CAST(DTTM_STAMP) AS TIMESTAMP),'YYYY-MM-DD HH24:MI:SS') would work but it doesn't like the ":" in the time to get "2019-04-10 15:16:59" When I change the colons to periods then it works "2019-04-10 15.16.59"
I would appreciate any help!