怎么获取时间?

Question

SQL> select to_char(to_date('2002-09-17 12:55:08','yyyy-mm-dd hh24:mi:ss'),'hh24:mi:ss') from dual;TO_CHAR(
--------
12:55:08SQL>

Answer 1

select sysdate-trunc(sysdate) from dual

Answer 2

按bzszp(SongZip) 的做法得到的也只是CHAR函数,我想得到的还是日期类型的值,还能转换过来吗?多谢各位了!

Answer 3

select to_date(to_char(to_date('2002-09-17 12:55:08','yyyy-mm-dd hh24:mi:ss
h24:mi:ss'),'hh24:mi:ss') from dual;