Monthly Archives: December 2012

Some stuff about dates and timestamps in Oracle

set null ~ pagesize 40 linesize 132; column id format 90; column datetrunc format a30; column dateuntrunc format a30; column timetrunc format a30; column timeuntrunc format a30; create table time_size2 ( id number, datetrunc date, dateuntrunc date, timetrunc timestamp, timeuntrunc … Continue reading

Posted in Oracle | Tagged , , , , , | Leave a comment