|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
between and datetime column
Hi,
I have this select stmt: SELECT * FROM table1 WHERE b BETWEEN a AND c Here, a,b,c all the three columns are of type datetime. I want to retrieve records where time b is between start time a and end time c. The query complies successfully but at times the result displayed is incorrect.. Any solutions? Thanks. |
|
#2
|
|||
|
|||
|
If you posted some details maybe someone can help. How is anyone to know what might make the results incorrect "at times" ?
|
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > between and datetime column |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|