This is my query:
SELECT * FROM WorkSchedules WHERE StartTime <= '1899-12-30 09:30:00.000'
How can I ignore the date and select records that are earlier than 09:30
I would like to achieve this because when a record is updated, it becomes 1900-01-01 09:30:00.000 in the SQL Server database, and my query won't return the expected rows.
I would appreciate your help.