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


Reply via email to