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
