Will convert the nightshift duration into float and write a between clause help?

Eg. something like:

between convert(float, convert(datetime, '8/23/2010 22:00:00'))

...

If you haven't figured out how to do this. Here's the code --

Use tempdb

go

-- create the above table

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'temp_model'...