M users WHERE added > ... ?
What is the correct way to write this statement? I
want to say WHERE "added is greater than the
currenttime minus 24 hours."
I could not figure it out by reading section "6.3.4
Date and Time Functions" of the documentation.
Anyone know?
Thanks
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)"
>
