SQL server 2008
nchar col that holds whole numbers representing time: 0800 or 0900
Datetime col 2015-02-17 11:12:34.000
I need to convert each to a numeric for comparison using only HH:mm from the DateTime Column.
WHERE nchar is BETWEEN starttime and endtime
I am new to development, only 2wks, any advice appreciated. I am not sure how to get an accurate comparison.