SELECT * between 10.30 and 2.30?

[spires]

Hi,

 

Does anyone know if there is a function that allows me to

select the time out a database, between selected times?

 

For Example:

select all between 10.00 and 2.00

select all between 8.00 and 16.00

select all between 1.00 and 24.00

 

Thanks for any help

[utexas_pjm]

Try this:

 

SELECT * FROM `your_table` WHERE HOUR(`date_column`) BETWEEN 10 AND 2;
SELECT * FROM `your_table` WHERE HOUR(`date_column`) BETWEEN 8 AND 16;
SELECT * FROM `your_table` WHERE HOUR(`date_column`) BETWEEN 1 AND 24;

 

Best,

 

Patrick