How to filter a timestamp format using Mysql?
I just want to ask how can i filter a timestamp value in Mysql?
Let's say we have the following datetime as
1351128031
1351128045
1351128097
How can I create a date range using this format? How can I perform this in
a query?
Like this:
SELECT * FROM user
WHERE acct_created BETWEEN (datefrom) AND (dateto) -- my problem is I
can't filter the timestamp
No comments:
Post a Comment