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: 314
        
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