db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: feature request: DATE(CURRENT_DATE)
Date Sat, 10 Apr 2010 14:25:03 GMT
On 04/10/10 12:55 PM, Gabriele Kahlout wrote:
> 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);
>   

Hi Gabriele,

It seems you got the syntax wrong:

ij> VALUES DATE(CURRENT_DATE);
1        
----------
2010-04-10

1 row selected

Hope this helps,

-- 
Knut Anders


Mime
View raw message