interval time (1 Viewer)

[endri81]

How to get interval time of day for a query
For example I have times of lessons

09:00 AM
12:00 AM
16:00 AM
and want to get only times between 9-12

 

[jdraw]

Please define 16:00 AM.

You might want to describe your database, what it's for, the tables, the sort of business, and tell us in plain English about the query.

 

[endri81]

Time is a field like in the picture attached.
I have to extracts only times that are in interval 9-12 AM
Regards

 

[jdraw]

What exactly is the query you're trying to code --tell us in plain English.

 

[endri81]

I have to calculate all records from table classroom where professor has taught in the morning so before 1 P.M

 

[jdraw]

I think you are going to have to have a CourseDate as well.

How do you work with
professor 1 course 1 12:30 PM, and
professor 1 course 2 12:20 PM

records 1 and 2?
What do you intend to calculate?

 

[endri81]

Yes thank you.
Attached in picture