CODEWITHSUNDEEP
databaseoracle-databaseoracle-sqldeveloper
Keval Trivedi
Keval Trivedi

Reputation: 1300

Update Date format in oracle

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?

Upvotes: 1

Views: 92

Answers (2)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60262

Just for completeness, another solution:

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

24-AUG-1980

Upvotes: 1

Rahul Tripathi
Rahul Tripathi

Reputation: 172378

Try this:

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

Upvotes: 2

Related Questions