SQL SERVER QUERY

Question

I have a table called ColorTable


I want to write a query to  retain the latest 30 days of data in the database or table. you can use the Field call ColorTable.DateTime . The column ColorTable.DateTime  field is a varchar, its a formated string. thanks