SQL simple selection of rows according to their time

Posted by iracema78280 on Stack Overflow See other posts from Stack Overflow or by iracema78280
Published on 2010-01-06T18:28:35Z Indexed on 2010/03/27 15:03 UTC
Read the original article Hit count: 262

Filed under:

Hello, I have a table with measures and the time this measures have been taken in the following form: MM/DD/YYYY HH:MI:SS AM. I have measures over many days starting at the same time every day.The datas are minute by minute so basically the seconds are always = 0. I want to select only the measures for the first 5 minutes of each day. I would have used the where statement but the condition would only be on the minutes and note the date is there a way to do this? Thanks

© Stack Overflow or respective owner

Related posts about sql