I need to pull the time from a field in an existing table which is stored as SMALLDATETIME.
An example of the value stored is as follows:
Jun 4 1900 11:30AM
I need to grab the time part (hours and minutes) and see if it is less than whatever the current time is now.
EG IF @CutoffTime < @CurrentTime THEN
Is there an easy way to do this in SQL Server?