Please read:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html for more
details.
I haven't tested it but this formula comes to mind :
SELECT field_list_goes_here
FROM table_name_goes_here
WHERE CURTIME()>= TIME(start_time)
AND CURTIME() <= TIME(end_time)
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Viswanatha Rao" <[EMAIL PROTECTED]> wrote on 08/18/2004 11:39:34 AM:
> I have two columns in a table: start_time and end_time. Both are of
> types DATETIME
> When I select rows from table, I want to select only those rows where
> the current time falls between start_time and end_time
>
> Can someone help with the SELECT syntax for this?
>
> Best Regards
> Vishwa Rao
>
>
>
