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';
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With