Re: [GENERAL] date expressions

2000-03-24 Thread 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 <

[GENERAL] date expressions

2000-03-24 Thread surfer girl
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