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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!