Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Problem with sql query

Posted on 2009-07-10
9
156 Views
Last Modified: 2012-05-07
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
Comment
Question by:tornadog
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 9

Expert Comment

by:wellhole
ID: 24826936
what do you get when you run
select expdt from table1 where expdt > '2009-07-09'
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24826937
select expdt from table1 where expdt > '2009-07-09'
0
 

Author Comment

by:tornadog
ID: 24826948
same result, still printing everything from July 1
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:tornadog
ID: 24826984
actually this is the query select expdt from table1 where expdt >getdate()-1
0
 
LVL 9

Expert Comment

by:wellhole
ID: 24827011
try using DATEADD(day,-1,GETDATE())
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24827019
>CONVERT(varchar, GETDATE()-1,112)
0
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 24827033
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
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 24827040
Forget the question, I see you said it is datetime.
0
 

Author Closing Comment

by:tornadog
ID: 31602256
worked nicely. Would never would have figured that one.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
migrate a SQL 2008 to 2016, 2 33
SQL Error - Query 6 41
MS SQL Server select from Sub Table 14 23
SQL Server Shrink hurting performance? 4 16
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question