| || |
MySQL compare date in bigint with specific date?
I have a date/time field stored as BIGINT in the database. I need to retrieve records where the date in the database is older than a specific date. The returned records should include all columns.
Could some one please give me advice?
Re: MySQL compare date in bigint with specific date?
I tried this and it returned as I expected.
Is there any more simple way?
select * from test.users where (CONCAT(FROM_UNIXTIME(LEFT(created, LENGTH(created) - 3)))) >= '2012-10-09 00:00:00';