如何在SQL中编写where子句以按时间过滤DATETIME列？

I have data that is timestamped with a DATETIME column and I want to filter it down to the set of records where the DATETIME is between 9:30am and 5:30pm for any day. What's the best way to do this?I have data that is timestamped with a DATETIME