[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • 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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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