How to set date time output in sqlplus

Sometimes it is useful to check report runtime via sqlplus when you have a date timestamp . It can be set by set time on command.thru sqlplus command prompt .

SQL> set time on

11:30:01 SQL>

11:33:30 SQL>

also, you may omit SQL prompt perfix entry

11:33:30 SQL> set sqlprompt >

11:33:37 >

11:33:38 >

11:33:38 >