Update Date format in oracle

Question

I need to convert date format in ORACLE.The current value is 0080-08-24 and i want to convert it into 1980-08-24 How to update above value?

Rahul Tripathi · Accepted Answer · 2015-08-31 10:54:07Z

2

Try this:

update tablename
set datecolumn= add_months(date'0080-08-24',1900*12)

answered Aug 31, 2015 at 10:54

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jeffrey Kemp · Accepted Answer · 2015-09-01 05:55:25Z

1

Just for completeness, another solution:

SELECT TO_DATE('0080-08-24','"00"RR-MM-DD') FROM DUAL;

24-AUG-1980

answered Sep 1, 2015 at 5:55

Jeffrey Kemp

60.5k15 gold badges111 silver badges161 bronze badges

The output of above query is : 24-AUG-80

Yep - your NLS date format uses 2-digit years. If you fix your format you will see 1980.