hi all,

i have a table with some records in it. I have for each
record the field date and the field time.

How can i setup an SQL statement that allows me to select
only those records of today say from 08.00 am till 13.00pm ?

! they are time fields , not date-time fields.

TIA
John

So if I understood correctly you have two columns, one that is a date
column, and one that a time column?

If that's true you could do:

SELECT * FROM table WHERE date_column = TODAY() AND time_column BETWEEN
'08:00:00' AND '13:00:00'


John wrote: