存储到字段(varchar\nvarchar)中的的值是''25-AUG-17'
sql转换:
返回结果为:25-08-2017
sql转换:
select to_char(to_date('25-AUG-17','dd-month-yy','NLS_DATE_LANGUAGE=AMERICAN'),'dd-mm-yyyy') FROM DUAL;
返回结果为:25-08-2017