5 Replies Latest reply on Jun 13, 2007 2:28 AM by 10594

    SQLPlus DATE Display Format

      I have a DATE column dt in table a. By default, SQLPlus shows only the date portion of it. Is there an option in SQLPlus to show the time portion of it without changing nls_date_format? Thanks.