Querying Dates problem 4

[Modica82]

Hi All,

I have a column that stores dates:

21/07/2004 13:13:52

but when i try and query this like so:

SELECT * FROM tblTable1 WHERE DateColumn = 21/07/2004

nothing is returned,

Any ideas??

 

[JohnEfford]

Hi

Because:

21/07/2004 13:13:52 <> 21/07/2004

Cheers

 

[amorous]

Try this:

SELECT * FROM tblTable1 WHERE Convert(varchar(10),DateColumn,103) = '21/07/2004'

-VJ

 

[Modica82]

Thanks amorous, it worked. I have queried dates like this before i swear i have! hmm!

Rob

 

[amorous]

Hey Rob,

i believe you...I too had tough times with the queries involving dates...

I am glad that it worked for you...

-VJ

 

[jmw713]

I am having a query problem with dates as well. I am basically new to Programming. I know how to set criteria for a search, but what I want is more difficult at least for me.
I have a table that stores Dates I need a query to return, lets say only 4-1-01 through 7-31-01 for the years 2001-2004. If i use a between statement i get everything in between. If you have any Ideas I would greatly appreciate it.

 

[john76]

For jmw713,

Looks like you are trying to query Q2?

How about:

Select *
  From MyTable
 Where DatePart(q, MyDate) = 2
   And Year(MyDate) Between 2001 And 2004

HTH,
John