Some rows won't be deleted when using the DATE() in TIMESTAMP column.

[fletchsod]

I noticed that some rows won't be deleted if I use this SQL Query...

DELETE FROM INQUIRIES WHERE DATE(INQ_TIMESTAMP) < '2005-01-01'

THe INQ_TIMESTAMP use data-type of TIMESTAMP. So, why can't it be deleted?

 

[MarcLodge]

Hi,

Do you get an erro mesage back or have you just noticed that rows are not getting deleted?

In the first instance, what is the error message?
In the secnond instance have you looked at the data to confirm it is outside of your data deleted?

Marc