It's not that sqlplus is truncating your output. The default format is configured at database startup, which is overridable in various ways ( environmental variable NLS_DATE_FORMAT, alter session set NLS_DATE_FORMAT = ). This format pertains to both selects and inserts.
He's using a timestamp column, not date, so substitute TIMESTAMP for DATE in these suggestions. SQL> create table fubar (d date, t timestamp); SQL> insert into fubar values (sysdate, current_timestamp); SQL> alter session set nls_date_format = 'yyyy-mm-dd'; SQL> select * from fubar; D T ---------- -------------------------- 2005-12-02 2005-12-02 14:16:31.356486 Note above that nls_date_format had no effect on timestamp column. SQL>alter session set nls_timestamp_format = 'Day dd, Mon YYYY'; SQL> select * from fubar; D T ---------- -------------------------- 2005-12-02 Friday 02, Dec 2005 Mark
