问题描述
我正在尝试在Oracle中将日期从 YYYYMMDD 转换为 DD-Mon-YYYY ,但是to_char
或to_Date
无法正常工作.你能请教吗?
I am trying to convert the date from YYYYMMDD to DD-Mon-YYYY in Oracle, but to_char
or to_Date
is not working. Can you please advise?
select to_date(20150324,'DD-Mon-YY') from dual;select to_char(20150324,'DD-Mon-YY') from dual;
select to_date(20150324,'DD-Mon-YY') from dual;select to_char(20150324,'DD-Mon-YY') from dual;
我收到一条错误消息:- ORA-01861: literal does not match format string
I get an error message saying: - ORA-01861: literal does not match format string
推荐答案
使用to_char
和to_date
的这种组合:
select to_char (to_date('20150324','YYYYMMDD'), 'DD-Mon-YY') from dual;
您的错误是,您使用了错误的日期模式.另外,建议添加''
,尽管在这种情况下也可以不添加它们.
Your mistake was, that you used the wrong date pattern. Additionally it's recommended to add''
, though it worked without them in this case.
检查此小提琴.
这篇关于如何在oracle中将YYYYMMDD转换为DD-Mon-YYYY?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!