how to replace date column [message #675205] |
Thu, 14 March 2019 21:37 |
|
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;
|
|
|
|
|
|
|
|
|