tornadog
asked on
Problem with sql query
I am running this simple query
select expdt from table1 where expdt > '7/9/2009'
expdt is a datetime field
this is the output I am getting;
select expdt from table1 where expdt > '7/9/2009'
expdt is a datetime field
this is the output I am getting;
Jul 1 2009 11:55PM
Jul 1 2009 11:55PM
Jul 1 2009 11:55PM
Jul 1 2009 11:55PM
Jul 1 2009 11:55PM
Jul 1 2009 11:55PM
Jul 1 2009 11:55PM
Jul 1 2009 11:55PM
Jul 2 2009 9:25AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 6 2009 12:00AM
Jul 7 2009 12:00AM
Jul 7 2009 12:00AM
Jul 7 2009 12:00AM
Jul 7 2009 12:00AM
Jul 7 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 8 2009 12:00AM
Jul 9 2009 12:00AM
Jul 9 2009 12:00AM
select expdt from table1 where expdt > '2009-07-09'
ASKER
same result, still printing everything from July 1
ASKER
actually this is the query select expdt from table1 where expdt >getdate()-1
try using DATEADD(day,-1,GETDATE())
>CONVERT(varchar, GETDATE()-1,112)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forget the question, I see you said it is datetime.
ASKER
worked nicely. Would never would have figured that one.
select expdt from table1 where expdt > '2009-07-09'