I have a sql table where the field tr_time contains the trade time and datatype of the filed is Datetime. I want to retrieve records where the time is in multiple of 5 seconds, so records where the seconds are in multiple of 5 only. How can I do this?
June 14, 2010 8:28 AM
June 14, 2010 5:32 PM