SQLite query that calculates whether the time of the Unix era is today

Question

I have an integer column that contains the time value of the Unix era. I want to calculate if he hits today.

For example, let today be the 24th day of the month. The query should return rows that fall on the 24th, but not those that fall on the 23rd or some time before.

Thanks for watching.

Answer 1

You can use Julian day for this, as it can be rounded to the border of the day. See http://www.sqlite.org/lang_datefunc.html

Answer 2

Use DATE(TheColumn, 'unixepoch')to get the date.

Answer 3

With MySQL Try:

SELECT *
FROM yourTable
WHERE DATE(FROM_UNIXTIME(yourUnixEpochField)) = DATE(NOW());