MySQL UNIX_TIMESTAMP problem while using in where clause to find out result from a date

Today my teammate Mohsin was in a funny problematic situation and discovered an interesting behavior of unix_timestamp function of MySQL.
The task:
Say, he had a table which contained data along with the timestamp of the insertion time in a column. Now, his task was to find out all the entries on a particular date.

The query:
His query [...]