Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    156

    Unanswered: simple select statement with data format

    i get the following results ...

    SQL> SELECT TO_DATE(SYSDATE, 'DD-MON-YYYY HH24 :MI S') FROM dual;
    SELECT TO_DATE(SYSDATE, 'DD-MON-YYYY HH24 :MI S') FROM dual
    *
    ERROR at line 1:
    ORA-01843: not a valid month
    rgs,

    Ghostman

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Perhaps

    SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24 :MI S') FROM dual;

  3. #3
    Join Date
    Sep 2003
    Posts
    156
    Originally posted by SkyWriter
    Perhaps

    SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24 :MI S') FROM dual;
    wunnerfil, tx - you know the line from above was off metalink... it didn't eev work if i altered the date format for the session using alter session set nls_date_format = '.....

    ?

    tx though
    rgs,

    Ghostman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •