Question

在 ORACLE中 如何将以下字符串 转换成 yyyy-mm-dd 格式？

[26/Sep/2014:06:42:11 +0800]
[26/Sep/2014:06:42:11 +0800]
[26/Sep/2014:06:42:12 +0800]
[26/Sep/2014:06:42:12 +0800]
[26/Sep/2014:06:42:12 +0800]
[26/Sep/2014:06:42:12 +0800]
[26/Sep/2014:06:42:12 +0800]

Answer 1

最笨的方法就是截取加拼凑：用substr(str,8,4)+'-'+substr(str,4,3)+'-'+substr(str,1,2)

Answer 2

select to_char(to_TIMESTAMP_TZ('26/Sep/2014:06:42:11 +0800','dd/MON/yyyy:hh24:mi:ss TZHTZM','NLS_DATE_LANGUAGE = American'),'yyyy-mm-dd') from dual;