db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tiago Espinha <tiago.de...@yahoo.co.uk>
Subject Re: feature request: DATE(CURRENT_DATE)
Date Sat, 10 Apr 2010 09:29:11 GMT
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,

----- Original Message ----
From: Gabriele Kahlout <gabriele@mysimpatico.com>
To: Derby Discussion <derby-user@db.apache.org>
Sent: Sat, 10 April, 2010 10:23:12
Subject: feature request: DATE(CURRENT_DATE)


I'm trying to retrieve the CURRENT_DATE from the DATE() function. Is
there how to do it, without of course specifying it?

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) ).


View raw message