時:分:秒
SELECT to_char(sysdate,'HH24') || ':' || to_char(sysdate,'MI') || ':' || to_char(sysdate,'SS') time FROM dual
民國年+月+日
SELECT to_char(sysdate, 'yyyy') - 1911 || to_char(sysdate, 'mm') || to_char(sysdate, 'dd') as d from dual
全站熱搜
時:分:秒
SELECT to_char(sysdate,'HH24') || ':' || to_char(sysdate,'MI') || ':' || to_char(sysdate,'SS') time FROM dual
民國年+月+日
SELECT to_char(sysdate, 'yyyy') - 1911 || to_char(sysdate, 'mm') || to_char(sysdate, 'dd') as d from dual
留言列表