test1表中,字段:time:2019/8/16 9:39:00(DATE)
select to_char(time,'hh24:mi') from test1
输出为:09:39
'yyyy-mm-dd hh24:mi:ss'
输出为:2019-08-16 09:39:00
test1表中,字段:time:2019/8/16 9:39:00(DATE)
select to_char(time,'hh24:mi') from test1
输出为:09:39
'yyyy-mm-dd hh24:mi:ss'
输出为:2019-08-16 09:39:00