Return records Timestamp() field

Question

I have a table called interessados, in it have int_data this field is timestamp(), I have 5 records with the following dates:

2016-09-01 10:15:00
2016-09-01 10:50:00
2016-09-01 18:35:00
2016-09-01 23:15:00
2016-09-15 10:00:00

How do I select only those of the day 01/09/2016? Being that it is timestamp() and I can’t do WHERE int_data?

Answer 1

can do it this way

WHERE date(int_data) ='20160901'

or even more "relaxed"

 WHERE int_data like '2016-09-01%'

in the first solution you make mysql process the date and in the second you just filter as c is a String

Answer 2

I do it in Firebird:

select * from interessados where cast(int_data as date) = '01/09/2016'

I cast in the field and work as a simple date