Databases Forum

SELECT * FROM conversions WHERE date = CURRENT_DATE() - INTERVAL 1 DAY;

There are other arguments you can do with this, some examples:

SELECT now() + INTERVAL 1 SECOND;

SELECT now() - INTERVAL 1 SECOND;

SELECT now() - INTERVAL 1 MONTH;

SELECT now() - INTERVAL 1 YEAR;

Using SELECT * FROM conversions WHERE date = CURRENT_DATE() - INTERVAL 1 DAY; does not work :S

Just like the other SQL query I mentioned, it says there are no entries from yesterday. Should I work around it using the PGP date function? I know how I can do that but I wanted to get the MySQL date working because its something new ;)

Any other suggestions?

Thanks again!

Try this

SELECT
*
FROM
conversions
WHERE
date >= CURRENT_DATE():00:00:00 - INTERVAL 1 DAY
and date <= CURRENT_DATE():12:59:59 - INTERVAL 1 DAY;

It will suck for ordering by date and time though if they are seperate fields. It will also make comparisons harder if you split them. Like when you want to query things that come before or after something else based on date and time. Because if it has to consider the time then it is a little bit of a hassle. You have to make sure the date fields are equal, then you can check if the time is before or after a time you need to compare against.

I think they only ordering I will have to do will be simple ordering so it should be alright using the two seperate fields