hi guys m having problem getting the current date of record
my command in query analyzer is

select * from genheader where date=getdate()

it doesnt show anthing

let say the date now is 2/17/05,
select * from genheader where date='2/17/05' then it display records but when i use getdate it doesnt show
when i run select * from genheader
it shows that date fields has
2005-02-17 00:00:00.000

i need to have a query that shows only the current date, hope u can help me :(

One possible solution could be converting and then comparing the date:

select * from genheader
where CONVERT(char(10),date,101) = CONVERT(char(10),GETDATE(),101)



Om Prakash

Sample Table Structure:
Create Table [TestDate] (
    [DateOfRegistration] [datetime],
    [Gender] [char] (1)
) ON [PRIMARY]
Go

Sample records for testing
Insert into TestDate (DateOfRegistration,Gender) Values (getdate(),'M')
Insert into TestDate (DateOfRegistration,Gender) Values (getdate(),'M')

Method 1:
Select * from testdate where Convert(char(10),dateofregistration,101) = Convert(char(10),getdate(),101)

Method 2:
Select * from testdate where month(DateOfRegistration) = month(getdate()) and
day(DateOfRegistration) = day(getdate()) and
year(DateOfRegistration) = year(getdate())

Method 3:
Select * from testdate where datediff(d,dateofregistration,getdate()+1) = 1

I used to use the first method only almost always. But I have listed the other two methods which I know off for your reference. You could compare the performance benefits between the 3 methods and decide for yourself :)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com