Re: [GENERAL] date expressions

[Adriaan Joubert]

surfer girl wrote:

> I checked the manual on this but couldn't find a clear answer:
>
> I've got two dates in a database, a start date and and end date, which are type 
>"date." I want to compare these dates to today's date in the SQL statement, something 
>along the lines of "startdate < date < enddate". Can this be done in the SQL select 
>statement?

SELECT .. FROM .. WHERE startdate < current_date AND enddate > current_date