数据库sql-日期格式转换

1.TO_DATE

select to_date('2012-07-01 10:00:00','yyyy-mm-dd hh24:mi:ss') from dual;

2.TO_CHAR

select To_Char(to_date('2012-07-01 10:00:00','yyyy-mm-dd hh24:mi:ss'),'yyyymmddhhmiss') from dual;