Re: Question about entry level Oracle DBA

Joel Garry wrote:

> ashishgug_at_yahoo.com (Ash G) wrote in message news:<cbafeb44.0211150908.3944859f_at_posting.google.com>...
> > I tried select sysdate from dual and it worked
>
> Funny, I tried it and it didn't show any time.
>
> > "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
>
> jg
> --
> @home is bogus.
> Interview questions that try to elicit certain answers in a
> non-straightforward way are even more bogus.

SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') FROM dual;

SELECT TO_CHAR(SYSDATE, 'HH:MI:SS')
FROM dual;

Daniel Morgan Received on Mon Nov 18 2002 - 10:01:06 CST