17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> select * from t;
SDT EDT
-------------------- --------------------
2009-03-13,15 2009-03-13,15,30
SQL>
SQL> select to_char(to_date(replace(sdt, ',', ''), 'yyyy-mm-ddhh24'),
2 'yyyy-mm-dd hh24:mi') || '-' ||
3 to_char(to_date(replace(sdt, ',', ''), 'yyyy-mm-ddhh24') + 1 / 24,
4 'hh24:mi'),
5 to_char(to_date(replace(edt, ',', ''), 'yyyy-mm-ddhh24mi'),
6 'yyyy-mm-dd hh24:mi') || '-' ||
7 to_char(to_date(replace(edt, ',', ''), 'yyyy-mm-ddhh24mi') + 1 / 48,
8 'hh24:mi')
9 from t;
TO_CHAR(TO_DATE(REPLACE(SDT,', TO_CHAR(TO_DATE(REPLACE(EDT,',
------------------------------ ------------------------------
2009-03-13 15:00-16:00 2009-03-13 15:30-16:00