Please i need help on mysql on how to get last dates base on DATETIME

[ludah]

I want to select the following from mysql

1. Last 12 hours

2. Last 24 hours

3. last 7 days

4. last 1 month

I will be glad with some one help me

[sneakyimp]

For the last 12 hours, it'd be something like this:

SELECT * FROM some_table WHERE some_datetime_field >= SUBDATE(NOW(), INTERVAL 12 HOUR);

For information on the INTERVAL unit argument, see the discussion for DATE_ADD().

[barand]

alternatively

SELECT * FROM some_table WHERE some_datetime_field >= NOW() - INTERVAL 12 HOUR