How to select date from date inclusive to date inclusive?

Question

SQL

Good afternoon, I'm trying to select a date from a specific number including that day, to another day including that day, but for some reason it does not take into account the second date
'SELECT * FROM wp_selllist WHERE pay_date >= "2016-10-01" AND pay_date <= "2016- 10-29"'
I need to display both the lines 2016-10-01 and 2016-10-29

Answer 1

On MySQL:
SELECT * FROM wp_selllist WHERE pay_date >= unix_timestamp('2016-10-01 00:00:01') AND pay_date <= unix_timestamp('2016-10-29 23:59:59')

Answer 2

can you store the date as DATETIME?