Re: How to display date and time from 'Select Sysdate...'

>SELECT SYSDATE FROM DUAL;
>unexpected output
>01-AUG-97
>expected output
>01-AUG-97 12:35AM.
>

 select to_char(sysdate,'DD-MON-YY HH:MMAM') from dual;

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html