Hello Gabriele, Based on the documentation at http://db.apache.org/derby/docs/10.5/ref/rrefsqlj34177.html it seems that CURRENT_DATE is itself a function.
So you can do: SELECT * FROM Flightavailability where flight_date > CURRENT_DATE; Hope it helps, Tiago ----- Original Message ---- From: Gabriele Kahlout <[email protected]> To: Derby Discussion <[email protected]> Sent: Sat, 10 April, 2010 10:23:12 Subject: feature request: DATE(CURRENT_DATE) Hello, I'm trying to retrieve the CURRENT_DATE from the DATE() function. Is there how to do it, without of course specifying it? -- Regards, K. Gabriele --- unchanged since 25/1/10 --- P.S. Unless a notification (LON), please reply either with an answer OR with " ACK" appended to this subject within 48 hours. Otherwise, I might resend. In(LON, this) ∨ In(48h, TimeNow) ∨ ∃x. In(x, MyInbox) ∧ IsAnswerTo(x, this) ∨ (In(subject(this), subject(x)) ∧ In(ACK, subject(x)) ∧ ¬IsAnswerTo(x,this)) ⇒ ¬IResend(this). Also note that correspondence may be received only from specified a priori senders, or if the subject of this email ends with a code, eg. -LICHT01X, then also from senders whose reply contains it. ∀x. In(x, MyInbox) ⇒ In(senderAddress(x), MySafeSenderList) ∨ (∃y. In(y, subject(this) ) ∧ In(y,x) ∧ isCodeLike(y, -LICHT01X) ).
