ORACLE里如何把0701111101变成2007-01-11 11:01

Question

RT

Answer 1

select to_char('0701111101','yyyy-mm-dd hh24:mi:ss') from dual;

Answer 2

错了，应该是：select to_date('1970-01-01','yyyy-mm-dd')+0701111101/(1000*60*60*24) from dual;
TO_DATE('1970-01-01','YYYY-MM-
------------------------------
1/9/1970 2:45:11 AM

Answer 3

select to_date('0701111101','yymmddhh24mi') from dual

Answer 4

select to_char(to_date('0701111101','yymmddhh24mi'),'yyyy-mm-dd hh24:mi') from dual

Answer 5

SQL> select to_char(to_date('0701111101','yymmddhh24mi'),'yyyy-mm-dd hh24:mi') from dual
  2  /TO_CHAR(TO_DATE(
----------------
2007-01-11 11:01SQL>

Answer 6

SQL> select   to_char(to_date('0701111101','yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd   hh24:mi:ss')   from   dual;TO_CHAR(TO_DATE('0701111101','
------------------------------
0701-11-11   01:00:00不要意思，看错了，直接到mi即可了，不用到ss

Answer 7

select to_char(to_date('0701111101','yymmddhh24mi'),'yyyymmdd hh24:mi:ss') from dual

Answer 8

下面这个可以满足lz需要
select to_char(to_date('0701111101','yymmddhh24mi'),'yyyy-mm-dd hh24:mi') from dual;

Answer 9

OracleDBA群35903017，欢迎加入。