I have a table where the date of new_value get reflected on old_value columns.
These values are configured on query_entity while writing to table but missing the desired value for few columns.
But for few columns, the date was not displayed, so i need to update the data in Prod with a sql query.
This is how the date is displayed from Action_on
While below is the snap where i need to update, along with the text value i want to update it to text(date)
I also want to update it with date only while Action_on is in dateTime format.
Please help me on this.
Discussion posts and replies are publicly visible
Assuming you want raw SQL, something like this might work:
UPDATE <YOUR_TABLE_NAME> SET OLD_VALUE = CONCAT(OLD_VALUE,<SOME DATE>) WHERE OLD_VALUE NOT LIKE '%/%' AND FIELD_NAME='Status';