date problem

[Guest]

i have a table:
RECORDS1
fields:
DATE1,NAME1

data is
21,10,2005 10:24:34 ANDY
21,10,2005 15:24:45 DAVID

i search date with this sql
select * from RECORDS1 where DATE1='21,10,2005'

nothing found its empty

i try this also
SELECT *
FROM RECORDS1
WHERE (DATE1 >= @date1) AND (DATE1 < @data1 + 1)
to parameter i put date.now value and search

this finds them when the time is before 21,10,2005 10:24:34

when the time after 21,10,2005 15:24:45 it cannot find anything
my problem is put a date parameter and search date in sql
i dont want time
i need date only

thanks

 

[Cor Ligthert [MVP]]

Bafidi,

Try to use parameters for this. There are more than alone this sample
expecially for your problem on our VB-Tips website.

http://www.vb-tips.com/default.aspx?ID=550279ec-6767-44ff-aaa3-eb8b44af0137

By instance a very short one with SQL and the same as this one. Be aware
that especially the parameters acts differrent between OleDb and by instance
SQLClient.

I hope this helps,

Cor