sql to show current date and time

on June 23, 2008 at 1:21 pm
Posted In: Oracle odds and ends (Cat)

Courtesy of Martin Widlake

— SHOWTIME
— shows date and time, primarily to tell how much longer that days
— sentence of misery in the pit of dispair is to last. Bitter? You Bet.

col dt head ‘  Date       Time  ‘
set pause off
set feed off
SELECT SUBSTR(TO_CHAR(SYSDATE ,’DD-MON-YYYY HH24:MI:SS’), 1, 20) dt–“_DATE__________TIME_” FROM DUAL
/
clear colu
set pause on
set feed 6