Re: Question about entry level Oracle DBA

From: Martin Doherty <martin.doherty_at_elcaro.moc>
Date: Fri, 15 Nov 2002 11:37:43 -0800
Message-ID: <_5cB9.7$GH3.79@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 - 13:37:43 CST