JimmyDeuce
asked on
SQL select statement where date = '1/2/2008'
For the life of me I can't figure this one out. I am trying to query a database and return records for a single day, btu keep getting erroneus results and now I see why. How can I make this work?
select *
from [userTable]
where myDate>= '1/2/2008'
AND myDate<='1/2/2008'
myDate looks like this 2008-01-02 10:55:40.0000000
There has got to be an easier way. lol.
thanks.
Jim
select *
from [userTable]
where myDate>= '1/2/2008'
AND myDate<='1/2/2008'
myDate looks like this 2008-01-02 10:55:40.0000000
There has got to be an easier way. lol.
thanks.
Jim
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.