|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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?? |
|
#2
|
|||
|
|||
|
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. |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > A sql statement to return between 2 times |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|