DECLARE @date DATETIME = '2006-12-30 00:38:54.840'
declare @Existingdate datetime Set @Existingdate=GETDATE() Print @Existingdate