The wrong time format: 30 - December - 99
02.25.31000000000 morningThe correct time format: 1899-12-30 02:25:31. 000

Orcale how to dispose of them into the correct time format

CodePudding user response:

99 what do you think out what year?

CodePudding user response:

To_date casts no

CodePudding user response:

To_date (date, 'YYYY - MM - DD HH24MISS')

CodePudding user response:

To_char (date, 'YYYY - MM - DD HH24MISS')

CodePudding user response:

 select to_char (sysdate, 'yyyy - MM - dd HH24: mi: ss') from dual 

CodePudding user response:

Dear bosses, to_date '000' millisecond precision will not be visible at a later time