If there's one thing I've learnt on this list it's to deal with dates as 2002-08-01 and not treat them as strings...
----- Original Message ----- From: "Nathan Steiner" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 5:49 AM Subject: RE: SQL Query Question : <giddy mode="on"> : I Love Tore's <pet peeve/>'s. They have helped me a lot over the last year : and a half. : </giddy> : : -ns : : -----Original Message----- : From: Bostrup, Tore [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, July 31, 2002 2:37 PM : To: ActiveServerPages : Subject: RE: SQL Query Question : : : <pet peeve> : I assume the column signupdate is a Date/Time column and the database is SQL : Server: : : Never compare a date with a string! : : Try : Select * : from customer : where signupdate >= CONVERT(DateTime, '2002-07-30 00:00:00', 120) : and signupdate <= CONVERT(DateTime, '2002-07-30 23:59:59', 120) : : </pet peeve> : : HTH, : Tore. : : -----Original Message----- : From: Steve Abaffy [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, July 31, 2002 3:34 PM : To: ActiveServerPages : Subject: OT: SQL Query Question : : : Hello I have the following query : : Select * : from customer : where : signupdate >= '2002-07-30 00:00:00' and signupdate <= '2002-07-30 : 23:59:59' : : And it looks like it works it pulls up 10 records. The problem is that there : are 18 records that meet the criteria. : : The following record SignUpDate are listed below that it somehow misses any : clues as to what I should be looking at??? : : 2002-07-30 09:29:25.780 : 2002-07-30 10:55:58.527 : 2002-07-30 11:57:36.833 : 2002-07-30 12:01:33.663 : 2002-07-30 16:44:01.323 : 2002-07-30 12:37:29.653 : 2002-07-30 14:15:46.313 : 2002-07-30 14:11:34.650 : : Any help would be greatly appreciated. : : : : --- : You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] : To unsubscribe send a blank email to : %%email.unsub%% : : --- : You are currently subscribed to activeserverpages as: : [EMAIL PROTECTED] : To unsubscribe send a blank email to : %%email.unsub%% : : : --- : You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] : To unsubscribe send a blank email to %%email.unsub%% : --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
