Question

我想用oracle数据库中分别提取出date年月日和时间，该怎么写？

date的格式是‘2013-01-01 00:00:00’

Answer 1

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