db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriele Kahlout <gabri...@mysimpatico.com>
Subject Re: feature request: DATE(CURRENT_DATE)
Date Sat, 10 Apr 2010 10:55:29 GMT
yes, I read that. But I want to just get the date. Sth like SELECT DATE('now');
One could do (apparently) VALUES CURRENT_DATE but that would not work
for DATE(VALUES CURRENT_DATE);

It would help if DATE(CURRENT_DATE) or DATE('now') returned what
CURRENT_DATE does.

2010/4/10, Tiago Espinha <tiago.derby@yahoo.co.uk>:
> 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 <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)
>
> 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) ).
>
>
>
>
>
>


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

Mime
View raw message