By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
ORA-01843: not a valid month
ITEM_TYPE | DESCR | SUM(A.ITEM_AMT-A.APPLIED_AMT) | TO_CHAR(A.SCC_ROW_ADD_DTTM,'YYYY') | TO_CHAR(A.SCC_ROW_ADD_DTTM,'YYYY-MM-DD-HH24.MI.SS.FF') |
---|---|---|---|---|
600000050010 | Something | 100 | 2017 | 2017-03-19-12.00.23.000000000 |