Using EFCore, how can I compare just the time of a timestamp?
SELECT * FROM MY_TABLE WHERE TO_CHAR(TIMESTAMP_COLUMN, 'hh24:mi') >= '06:00' AND TO_CHAR(TIMESTAMP_COLUMN, 'hh24:mi') <= '06:05'
I have the Timestamp translated do DateTime, but I can't call .TimeOfDay to do this comparison.