A sql statement to return between 2 times

Hi,

I want to execute a sql statement which will return the records that were inserted into the database between 2 times

eg SELECT * FROM SentSMS where MsgTime Between "12:00:00 PM" AND "1:00:00 pm"

I want to create a graph to display frequency of messages received by the hour, but is it going to treat the arguments in the Between as string literals??

How about...

SELECT * FROM SentSMS where MsgTime > "12:00:00 PM" AND MsgTime < "1:00:00 pm"

I use similar SQL queries on my Access databases, and it works OK.