在
select to_char('2006-01-26 00:00','yyyy-mm-dd hh24:mi') from dual;
时返回:2006-01-26 00:00
但是
select to_date('2006-01-26 00:00','yyyy-mm-dd hh24:mi') from dual;
时返回: 2006-01-26后面的00:00没有了
怎样返回格式为日期型的2006-01-26 00:00呢?
select to_char('2006-01-26 00:00','yyyy-mm-dd hh24:mi') from dual;
时返回:2006-01-26 00:00
但是
select to_date('2006-01-26 00:00','yyyy-mm-dd hh24:mi') from dual;
时返回: 2006-01-26后面的00:00没有了
怎样返回格式为日期型的2006-01-26 00:00呢?
----------
01-1月 -06
SQL> select to_char(times,'yyyy-mm-dd hh24:mi:ss')
2 from test;TO_CHAR(TIMES,'YYYY
-------------------
2006-01-01 23:33:00