How to compare time in SQL?

[iamanson]

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]

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]

thanks! :

 

[iamanson]

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]

if you search for convert in BOL it should be there

Matt

Brighton, UK