whats wrong in this update statement :?

whats wrong in this update statement :

declare @s1from datetime
UPDATE Table1 SET Product = @Product , fare =开发者_运维知识库 @fare, s1from = convert(datetime,convert(datetime,@s1from,103),120)

this expression: convert(datetime,convert(datetime,GETDATE(),103),120) works fine, so if you get an error you might forget about setting the value of @s1from, there is no line in your code. Try

DECLARE @s1from datetime

SET @s1from = GETDATE()

SELECT convert(datetime,convert(datetime,@s1from,103),120)