Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about entry level Oracle DBA

Re: Question about entry level Oracle DBA

From: Alan Shein <alan.remove_this.shein_at_erols.com>
Date: Fri, 15 Nov 2002 15:27:58 -0500
Message-ID: <ar3lcc$f0gcb$1@ID-114862.news.dfncis.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US