Update sql

I have two columns in sql table as follows
From_date, To_date
09/25/2021 02:55:22,
09/26/2021 03:45:33,
I have to update “To_date” column from “From_date” in this date format “dd.mm.yyyy” Both are varchar datatype
Whats the update query to update date in specific format?


Yes you can. Use Execute Non Query activity and write Update query to do that.

May I know what Database are you using here ?

update table_name set To_Date=format(cast(From_Date as date),‘dd.MM.yyyy’)