Select with date and hour interval

[cms9651]

hi there, hope in your help.

I need to extract from my table:

1. all the rows of the previous day;
2. all the rows of the current day until 6 o'clock in the morning;

I tried this query but the output is null, I have two rows with previous day.
Can you help me?
thank you.

SELECT
	*
FROM
	mytable
WHERE
	myDate BETWEEN DATE_SUB(
		CURRENT_DATE (),
		INTERVAL 1 DAY
	)
AND (
	CURRENT_DATE ()
	AND myHour < '06:00'
);

[guido2004]

Try

SELECT
	*
FROM mytable
WHERE myDate = DATE_SUB(CURRENT_DATE (), INTERVAL 1 DAY)
OR (     myDate = CURRENT_DATE ()
     AND myHour < '06:00'
   )

[cms9651]

thanks a lot!

[r937]

it needs to be said that having two separate columns for date and time is usually a lot worse (for the resulting complexity in sql) than a single datetime column

[cms9651]

it needs to be said that having two separate columns for date and time is usually a lot worse (for the resulting complexity in sql) than a single datetime column

many thanks for suggestion!