5 Replies Latest reply: Jun 12, 2007 9:28 PM by 10594 RSS

    SQLPlus DATE Display Format

    60866
      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.