karunakaradepu

 Profile Answers by karunakaradepu 

• Jan 29th, 2008

 

    If UR Q is  How TO PRINT A TIME:

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

hemant.agarwal03

 Profile 

• Feb 13th, 2008

 

you need to use set operetor TO GET THE TIME..LIKE THIS..

SQL> SELECT SYSDATE FROM DUAL;

SYSDATE
---------
13-FEB-08

SQL> SET TIMING ON
SQL> SELECT SYSDATE FROM DUAL;

SYSDATE
---------
13-FEB-08

Elapsed: 00:00:00.00

now it will show time..