Home > IT Answers > Development > sql update command to update a date-of-birth
Mji
50 pts.
 sql update command to update a date-of-birth
Date format, SQL Oracle 9i, Update
I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR

Software/Hardware used:
ASKED: September 24, 2009  2:41 PM
UPDATED: September 24, 2009  8:09 PM
RELATED QUESTIONS
Answer Wiki:
It has been a while since I did any Oracle but I think this will work.. UPDATE your_table SET date-of-birth = '15-MAY-'||EXTRACT(YEAR FROM date-of-birth) WHERE ... and please don't forget a WHERE clause (unless you want all birth dates set to May 15th) meandyou
Last Wiki Answer Submitted:  September 24, 2009  3:43 pm  by  Meandyou   5,205 pts.
All Answer Wiki Contributors:  Meandyou   5,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

UPDATE your_table
SET field_DOB = ’27-FEB-’||EXTRACT(YEAR FROM field_DOB)
where …

It’s working! Thanks so much.

Mji
 50 pts.
 

You’re very welcome.

And thank you for letting me know that it worked.

Meandyou
 5,205 pts.