Update sql

[Vamshi_Krishna_Aluvala]

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?

[lakshman (Ganta lakshman)]

@Vamshi_Krishna_Aluvala

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

May I know what Database are you using here ?

Execute Non Query

[Vamshi_Krishna_Aluvala]

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