Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

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;




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

Open in new window

0
tornadog
Asked:
tornadog
  • 3
  • 2
  • 2
  • +1
1 Solution
 
wellholeCommented:
what do you get when you run
select expdt from table1 where expdt > '2009-07-09'
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
select expdt from table1 where expdt > '2009-07-09'
0
 
tornadogAuthor Commented:
same result, still printing everything from July 1
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
tornadogAuthor Commented:
actually this is the query select expdt from table1 where expdt >getdate()-1
0
 
wellholeCommented:
try using DATEADD(day,-1,GETDATE())
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
>CONVERT(varchar, GETDATE()-1,112)
0
 
Kevin CrossChief Technology OfficerCommented:
what is your data type of column
select expdt 
from table1 
where expdt >= dateadd(d, -1, datediff(d, 0, getdate()))

Open in new window

0
 
Kevin CrossChief Technology OfficerCommented:
Forget the question, I see you said it is datetime.
0
 
tornadogAuthor Commented:
worked nicely. Would never would have figured that one.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now