Yes, I know, but I'd be happy to get even the partial answer instead of a
"hmmm" look.
"Martin Doherty" <martin.doherty_at_elcaro.moc> wrote in message
news:_5cB9.7$GH3.79_at_news.oracle.com...
> Hmmm, it's not a totally accurate answer, since the chances are good
> that you won't see the time (unless NLS date format has been altered).
>
> select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') from dual;
>
> Martin
>
> Alan Shein wrote:
>
> >Well, yes, that is the answer, but many interviewees don't know it.
> >
> >
> >"Ash G" <ashishgug_at_yahoo.com> wrote in message
> >news:cbafeb44.0211150908.3944859f_at_posting.google.com...
> >
> >
> >>I tried select sysdate from dual and it worked
> >>"Alan" <alan_remove_this_shein_at_erols.com> wrote in message
> >>
> >>
> >news:<aohrjl$mfjar$1_at_ID-114862.news.dfncis.de>...
> >
> >
> >>>Daniel,
> >>>
> >>>To save time in interviews, start with, "What is the SQL to display the
> >>>system date and time?" I think even you will be surprised.
> >>>
> >>>-Alan
> >>>
> >>>
> >
> >
> >
> >
>
Received on Fri Nov 15 2002 - 14:27:58 CST
