Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: quickie on sysdate
> Thanks Knut but I need the date, not the time...
Sorry, I read it toooooo fast. But I am sure you got the idea:
select to_char(sysdate,'DD-MON-YY') from dual;
or any other format you want.
Regards,
Knut Received on Wed Mar 13 2002 - 10:21:05 CST