I figured out the answer. It is:
SELECT * FROM users WHERE added > (CURRENT_TIMESTAMP()
- INTERVAL 24 hour);
--- Andrew Tomazos <[EMAIL PROTECTED]> wrote:
> I am running MySQL 3.23.39.
>
> I have a column called "added" of type
> "timestamp(14)"
> in a table called "users".
>
> I set "added"
I am running MySQL 3.23.39.
I have a column called "added" of type "timestamp(14)"
in a table called "users".
I set "added" to NULL on INSERTs in order to set it to
the current time.
I now want to SELECT all rows added in the last 24
hours.
SELECT * FROM users WHERE added > ... ?
What is the
