Help regarding date functions

Hi!!

I have some problem regarding the date functions. The problem I have is, I havea column in my SQL server database table by name request_generated_date of datetime datattype and the default value set to it the server date by using the function getdate().
I am querying this table wherein I want to check that when a user submits a form then it should check the following: the submit date (column:request_generated_date in the tabel)should be less than the server date + 24 hours (or one day). When I am writing the query as

where request_generated_date ='"&dateadd('d',1,date())&"'"

but the result set is empty.

Can somebody please help in this matter. Can I use the date() function in ASP or not. or should I try to remove the time factor from the server date and then query the column..I am confused.

But I am using MS SQL Server as my backend. The problem is when I am going to set the datatype for the column I can do it as Curdate(), but when I try to query, I have to use the Date() function which again returns the date and time. How can I remove the time function from the date().

Hi lovelyeyes (at least put your name in the profile it will help someone to address you)

In your first respone you wrote that you are using MySQL and in the previous one your are saying that you are using MS SQL Server. plz clear this thing bcoz every backend is having its own date format the resolution i have provided you was for MySQL Server.

in asp date() returns only date, time() returns only time, and now() returns both