Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Current date and time
select to_char(sysdate,'DD-Mon-YYYY HH24:MI') from dual
should do the trick !
Elliott Mehrbach wrote in message <6ku9al$g47$1_at_news.ap.net>...
>I am looking for a query that will return the current date and time from
>the Oracle server. Any help would be welcome.
>
>
>
Received on Mon Jun 01 1998 - 08:49:42 CDT