How to display data by time without affecting the date?

Question

Transact SQL

There is a field in the table with date data in it of this form 2019-04-21 22:58:25.437, I need to display data by time, let's say all that are more than 9 hours.

Answer 1

https://metanit.com/sql/sqlserver/8.3.php
You can take the date component - time (hour and minute) and compare them with the required ones.

SELECT * FROM table
WHERE DATEPART(hour, [date_field]) > 9

Answer 2

Alexander 's decision is absolutely correct.
But if you need time , then there is a construction:

SELECT CAST( GETDATE() AS DATE), CAST( GETDATE() AS TIME)