How to compare time in SQL?

iamanson · Jul 8, 2003

Hello,
I need to retrieve data within a specific time range,
e.g 9:00am to 3:00pm

It seems there is date function only, how about time?

ClaireHCM · Jul 8, 2003

select * from table2 where convert(varchar(10),dates,108) between '09:00:00' and '15:00:00'

Tablename is table2 with a datetime field column dates

iamanson · Jul 8, 2003

thanks! :

iamanson · Jul 8, 2003

By the way, where can you find what the 3rd parameter '108'
in 'convert(varchar(10),dates,108)' function means?

I can even find that in SQL's help.

MaffewW · Jul 9, 2003

if you search for convert in BOL it should be there

Matt

Brighton, UK