Toad World® Forums

7.2 beta export insert wrong date format

Wrond default export date format

Steps to reproduce:

  1. I have preferences:
  • Display date format YYYY.MM.DD.
  • Session default date format YYYY.MM.DD HH24:MI:SS
  • in logon script: ALTER SESSION SET NLS_DATE_FORMAT=‘YYYY.MM.DD HH24:MI:SS’;
    2. Open new tab and run

select sysdate from dual;

3. Export data (Table Insert, Clipboard, default parameters) I get:

*INSERT INTO dual VALUES(TO_DATE('2014-12-01 14:35:1);*

Hi smithsv,

Thanks for your feedback, this problem had fixed in story “SQLNAV-1792” , pls wait the next upcoming beta program .

Regards,

Alan