/* display current time */
select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS')
as "SYSDATE"
from dual;
/* insert specific date/time into table */
insert into game_schedule
( sched_id, location, game_date )
values(2982, 'Chicago', to_date('2001/10/31:03:00:00PM', 'yyyy/mm/dd:hh:mi:ssam')) ;
-- date format settings
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS' ;
select
USER_NM ,
PROC_NM ,
PROC_START_TS ,
PROC_END_TS ,
PROC_END_STATUS ,
ERROR_CNT ,
from STG_ETL_LOG
WHERE SYSDATE - PROC_START_TS < 1 ;
|
|
