need to delete data based on current date that is in variable

Question

hi

I have one table vicidial_list i need to do delete from it based on getdate -1 used via variable.

but the problem is both the date format is different.

Like

select top 1 modify_date from vicidial_list       01-01-2013 02:01:59
select (GETDATE())                                      2013-02-15 13:37:31.250

I need to use

delete from vicidial_list

where modify_date =?

I'm getting error.

[Execute SQL Task] Error: Executing the query "DELETE from vicidial_list where
entry_date =?" failed with the following error: "Invalid time format". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Kindly help

Answer 1

1) What is the datatype of the variable

2) Why use a variable to store a getdate() -1 ? Why not use something like DATEADD(dd, -1, GETDATE())

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter