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
sql
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