this query doesnot return any row
where as all the current records are expected,can any body help me
in this scenario.

select * from table where datecolumn=getDate()

Hi raz,

GetDate() returns a data and time accurate to some milli seconds. It's very unlikely you have records that match those milli seconds exactly hence you get no results.

One way to fix this is to convert the dates to a varchar and then compare both varchars. Something like this should work:

WHERE Cast(MyDate as varchar(20)) = Cast(GetDate() as varchar(20))

You may need to use Convert and a specific style instead to get both sites of the comparison in the same format.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Biscuit by Portishead (Track 9 from the album: Dummy) What's This?

Raz,
Does that mean current DAY's records or current TIME's records? Hope youa re looking for today's records.

If so rephrase your query to this... This would return today's records.

If you are looking for TIME specific resultset, then Imar's solution should be what you would stick with.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Vijay is absolutely right. With my solution, you'd get something like Sep 25 2004 10:29AM which also includes the time element.

The convert statement Vijay showed returns something like 2004-09-25
so you are effectively selecting records where the date matches....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

HI Raz,

Solutions from Vijay and Imar are the correct and perfect ways. In another way you can use .....

Select * from Table1 where day(DateCol)=day(Getdate())
And Month(dateCol)=Month(getdate())
AND Year (dateCol)=Year(getdate())

Hope u have now number of choices to select to fit in ur case.

Cheers


B. Anant