Database time format is 2014-01-27 T16:00:00) 000 + 0000, how to convert yyyy - mm - dd hh24: mi: ss this format, strives for the great god give directions, thank you

CodePudding user response:

Select to_char (time, 'yyyy - mm - dd hh24: mi: ss') form [table name]

CodePudding user response:

What type of source data is?

CodePudding user response:

Alter session set nls_date_format='yyyy - mm - dd hh24: mi: ss';

CodePudding user response:

If there is no good way to try minutes when intercepting separately with the substr (date) (month) (year), then the concat