Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: quickie on sysdate
> I need to insert a date in a field: How can format sysdate to only format
> the string as date (without the time)
SELECT TO_CHAR(SYSDATE,'HH24:MI') FROM DUAL; will only show the time in 24h format. Consult the doc for further information.
Regards,
Knut Received on Wed Mar 13 2002 - 10:02:01 CST