Member Avatar for gunsofnavarone

I need to select data available between 20:00 and 08:00 (8 PM to 8 AM).
How do I achieve this?

The column is of type TIME.

  • 2 Contributors
  • 5 Replies
  • 175 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

That depends on the actual format you're using. If you're not keeping track of the date, it's simply

select * from mytable where timefield <= '08:00' or timefield >= '20:00'
Edited by smantscheff because: n/a
Member Avatar for gunsofnavarone

Ok. Maybe I have not come out clear here.
I have a list of data between diff. time periods (so, there's data between 00:00-08:00,08:00-15:00,20:00-08:00 .. so on and so forth).
I have an input field (say, 2012-01-25 21:00).
Now I wish to retrieve all data with a time window that includes 21:00.

The time periods are in two cols. [FROM_WINDOW;TO_WINDOW].

Member Avatar for smantscheff

It's still not clear. How do you store the date? Do you store it at all?

Member Avatar for gunsofnavarone

This is how my table is structured: -

ID        TIME_WINDOW_FROM       TIME_WINDOW_TO
ABC123    1899-12-30 20:00:00    1899-12-30 08:00:00
ABC456    1899-12-30 20:00:00    1899-12-30 08:00:00
ABC000    1899-12-30 08:00:00    1899-12-30 15:00:00

Now if my input is 2012-01-25 21:00, the result-set should return 2 rows.

Member Avatar for smantscheff

Does this mean that the date part is irrelevant and you're only working with the time part?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.