Hello Sir
In SQL server is it possiable to retreive the record
where table.date=System date.
i have wrote the query like

SELECT * FROM Table1 WHERE Table1.Date=(SELECT

getdate());

But it returns the empty record.

Can any one Guide me .

Thanks.

arshad mahmood

__________________
arshad mahmood

Your question really belongs in the SQL Server group, not in a group for the MySQL product.

Datetime datatypes store both the date andthe time, so your query will only select rows where the column in question is exactly equal to right now, which is quite unlikely...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

If you are looking to list the reocrds that match for today...then use the following.

Select * from <TABLE_NAME> where <DATE_COLUMN>=CURDATE()
                OR
Select * from <TABLE_NAME> where <DATE_COLUMN>=CURRENT_DATE()

If you are looking for records to be listed for current time...
then you can use

Select * from <TABLE_NAME> where <DATE_COLUMN>=NOW()

Hope this helps.

Regards,
Vijay G