|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
May 13th, 2004, 11:43 AM
|
|||
|
|||
Time stamp query problem!
Hi all,
I'm creating a Lauderette system for a uni assignment using VB6 as the frount-end application and MS Access as a back-end database. Problem is i need a query which will display a list of all washes due for collection within 2 hours, so i've used the following: Code:
SELECT * FROM Wash WHERE [Requested pick-up]<Now()+2; Problem is it displays all records, even if the time of collection is greater than 2 hours. I'm gussing its something to do with the "+2" but am new to SQL so need some help!!! cheers Si.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Time stamp query problem! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
