欢迎投稿

今日深度:

Oracle日期转换

Oracle日期转换


1、日期转换

select to_date('2014-11-27','yyyy-MM-dd')  from dual;

select to_date('20141127','yyyyMMdd')     from dual;

select to_date('20141127','yyyy-MM-dd') from dual;

select to_date('2004-11-27 00:00:00','yyyy-MM-dd hh24:mi:ss') from dual;

select to_date(TRUNC('20141127'),'yyyy-MM-dd') from  dual;

2、无效月份

select to_date('2014-11-27','yyyyMMdd')  from dual;
不能这样转换

www.htsjk.Com true http://www.htsjk.com/oracle/22667.html NewsArticle Oracle日期转换 1、日期转换 select to_date(2014-11-27,yyyy-MM-dd) from dual;select to_date(20141127,yyyyMMdd) from dual;select to_date(20141127,yyyy-MM-dd) from dual;select to_date(2004-11-27 00:00:00,yyyy-MM-dd hh24:mi:ss) from dua...
评论暂时关闭