I need help with SQL query

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

Parents Reply Children
No Data