Oracle字符串轉(zhuǎn)換為日期格式？WITH t AS (SELECT "abcdefghijklmn" AS a FROM dual UNION ALL SELECT "abcdef

Oracle字符串轉(zhuǎn)換為日期格式？

WITH t AS (SELECT "abcdefghijklmn" AS a FROM dual UNION ALL SELECT "abcdefgh" AS a FROM dual UNION ALL SELECT "abcd" AS a FROM dual) SELECT CASE WHEN length(lpad(t.a， 8， "0")) = 8 THEN lpad(t.a， 8， "0") ELSE substr(t.a， 1， 8) END AS a FROM t

oracle數(shù)據(jù)庫怎么轉(zhuǎn)換時(shí)間格式？

可以用to_date("日期類型字符串"，"要轉(zhuǎn)化的日期類型")函數(shù)進(jìn)行日期格式轉(zhuǎn)換sql：selectto_date("1990-12-1212:12:32"，"yyyy-MM-ddhh24:mi:ss")fromdual解釋：此語句的輸出結(jié)果就是“1990-12-1212:12:32”（日期類型）。后面的日期類型格式可以根據(jù)實(shí)際需要修改如改為：selectto_date("1990-12-1212:12:32"，"yyyy-MM-dd)fromdual輸出結(jié)果就是“1990-12-12”.