Find all rows where date column has timestamp = 00:00:00.000

Question

I have a table in which one column as registrationDate whose type is datetime. I need to find all the rows where registrationDate as timestamp as 00:00:00.000. for example :

registrationDate: '2019-03-20 00:00:00.000'

I need to query something similar as below :

select * from table where registrationDate like '%00:00:00.000';

Answer 1

You can cast datetime as time:

WHERE CAST(registrationDate AS TIME) = '00:00'