It looks like TIMESTAMP is really a VARCHAR column (since it has parenthesis in it), so try:

DELETE FROM mytable

WHERE CAST((SUBSTRING(TIMESTAMP,1,10)) AS DATETIME) < GETDATE()-90

The SUBSTRING will get just the date portion. Then the CAST will change it to DATETIME (adding default time of 00:00:00.000).

-SQLBill