Timestamp format

[ggnanaraj]

indeed... you can set the system wide default format for a timestamp to be that..

The change was made for the session not system wide...

alter session SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD-HH24.MI.SS.FF';