Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hamishnorton
Starting Member
1 Post |
 Posted - 2001-07-24 : 23:05:02
|
| Hi there, I'm a little bit stumped on this one.I have a column in a table that records when the date and time of an event took place.Table Name: ChronicleColumn Name: Created (of type DateTime)I would like to select the Chronicle records that are between two dates.(e.g. 1 May 2001 and 20 May 2001)And I would like to select those records that are between two times.(e.g. 6:00am and 1:00pm)Does anyone know how to do this or have any pointers for me?I can see it would be easier if I had the date in one column and the time in the other.Can it be done without doing that?cheers,HamishHamish Nortonhamish@liftrider.com |
|
|
|
|
|
Query - Between to dates and between to times