SQL Script for Admin Purpose

Heyas, I require two tables to be truncated below is the pseudo code of what I require: Truncate WMB_BINARY_DATA and WMB_MSGS FROM WMB_BINARY_DATA wba JOIN WMB_MSGS msgs ON wba.wmb_msgkey = msgs.wmb_msgkey where msgs.EVENT_TIMESTAMP < 2014-06-19 Note: wmb_msgkey is column you join both tables on. Note the event_timestamp field is varchar so a conversion will be required. Error message returned from sql on select query: Conversion failed when converting the varchar value '2014-01-19 21:20:34.224' to data type int. I am running sql server 2008. Not looking to pay over $15 for this. Thank you.