Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: quickie on sysdate
David de Gendt wrote:
>
> Thanks Knut but I need the date, not the time...
>
> But this has given me ideas
trunc(sysdate) gives a date with "no" time portion (ie midnight).
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Wed Mar 13 2002 - 15:00:13 CST