Convert Date Format

How to convert date format 09-aug-79 to 08-09-1979? I am not able to convert it into 1979 in my case it gives me either 0079 or 2079.

Showing Answers 1 - 3 of 3 Answers

Prasad

  • Mar 10th, 2016
 

To_date(to_char(09-aug-79,dd/mm/yy),dd-mm-yyyy)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions