Hello Sir
How can i retreive the records froem table where data =system date.
i have wrote the following query but it gives the error:
SELECT * FROM Table WHERE Table.[Date]=CURDATE();
it gives the syntax error.
Can Anyone guide me what is the problem with this.
Thanks

arshad mahmood

__________________
arshad mahmood

Use GETDATE()