mysql和oracle中的日期和字符串互相转换的问题！

mysql：

//字符串转日期
select str_to_date('09/01/2009','%m/%d/%Y') from dual;

select str_to_date('20140422154706','%Y%m%d%H%i%s') from dual;

select str_to_date('2014-04-22 15:47:06','%Y-%m-%d %H:%i:%s') from dual;

//日期转字符串
select date_format('2014-04-22 15:47:06','%Y-%m-%d %H:%i:%s') from dual;

oracle：

//日期转字符串
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual;   

select to_char(sysdate,'yyyy') as nowYear   from dual;   //获取时间的年  

select to_char(sysdate,'mm')    as nowMonth from dual;   //获取时间的月  

select to_char(sysdate,'dd')    as nowDay   from dual;   //获取时间的日  

select to_char(sysdate,'hh24') as nowHour   from dual;   //获取时间的时  

select to_char(sysdate,'mi')   as nowMinute from dual;   //获取时间的分  

select to_char(sysdate,'ss')   as nowSecond from dual;   //获取时间的秒

//字符串转日期
select to_date('2004-05-07 13:23:44','yyyy-mm-dd hh24:mi:ss') from dual;