Solved

Problem with sql query

Posted on 2009-07-10
9
153 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
 

Author Comment

by:tornadog
ID: 24826984
actually this is the query select expdt from table1 where expdt >getdate()-1
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now