<-- new at sql
I'm trying to run a query on time but my date and time are in the same field.
Example I'm trying to get the rows between 6/22/2008 12:00:54 AM to 6/23/2008 12:11:57 AM
Unfortunantly I don't have the luxury of splitting up the date and time.
Select * from log where dateandtime ?????????
what is the problem with:
Select * from log where dateandtimecolumn between '6/22/2008 12:00:54 AM' and '6/23/2008 12:11:57 AM'