how to replace date column [message #675205] |
Thu, 14 March 2019 21:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9cadeac5ddd1b04bac5a35da0590caef?s=64&d=mm&r=g) |
tommm
Messages: 2 Registered: March 2019
|
Junior Member |
|
|
HI ALL,
could you please help me to write update statement?
i have one table and in that table i have birth_date column. i want to update that table with different date and month but keeping the year.
for example. . i want to convert (09/07/2019) to. '01/01/2019'. but in the table i have a lot of values all of them i want to update. i am able to write select statement but not a update.
select '01/01/'||to_char(birth_date, 'yyyy') from my_table;
|
|
|
|
|
|
|
|
|