I have an SQLBase and I am trying to get the current date of the system to be equal to the date of a column (create_date).
The MySQL Code will be:
Select * From Date D
Where D.Create_date=CURDATE();
Can someone suggest me a way to take the current date in a SQLBase?
The date format should only contain the date(yyyy-MM-dd) and not the timestamp.
To get the current date, and not time, you should be able to use @DATEVALUE(@NOW)
.