Hi,

I am trying to selecte records from a table and want to check if the date field has a value of todays date or not. I forgot how to tell SQL to check the field. I don't want to pass a date instead I want to use the keyword that I forgot. I think it is either CURRENT DATE or TODAY or something like that.

SELECT * FROM Payments WHERE P_date = current date

or

SELECT * FROM Payments WHERE P_date = TODAY

can someone please HELP?

Thanks.