My date value is stored as varchar2 and the value is 15/August/,4:30 PM, how to convert this to a proper date format like DD-MM-YYYY.
解决方案
You can convert a string to a DATE using the TO_DATE function, then reformat the date as another string using TO_CHAR, i.e.:
SELECT TO_CHAR(
TO_DATE('15/August/,4:30 PM'
,'DD/Month/YYYY,HH:MI AM')
,'DD-MM-YYYY')
FROM DUAL;
15-08-
For example, if your table name is MYTABLE and the varchar2 column is MYDATESTRING:
SELECT TO_CHAR(
TO_DATE(MYDATESTRING
,'DD/Month/YYYY,HH:MI AM')
,'DD-MM-YYYY')
FROM MYTABLE;
如果觉得《oracle 日期改字符格式 如何在oracle10g中将字符串日期转换为日期格式》对你有帮助，请点赞、收藏，并留下你的观点哦！
