Oracle DateTime Format

Display dates in query output
alter session set NLS_DATE_FORMAT = 'MM/DD/YYYY HH24:MI:SS'

Insert dates into table
insert into foo values ( to_date( '04/01/2002', 'MM/DD/YYYY HH24:MI:SS' ) );

HH     hour (1-12)

HH24   hour (0-23)

MI     minute

SS     second

SSSSS  seconds past midnight (0-86399)

Posted 4:07 PM    |    0 comments    |    Permalink