3 Replies Latest reply on Aug 25, 2017 1:47 PM by JasonBatzlaff

    17.2: Export from Grid with Fetch removes timestamp from DATE

    JasonBatzlaff

      I am on 17.2 - this issue seems to have been noticed after this update - but I cannot be certain.  When I export data with data type of DATE, the time portion of the date is 'sometimes' removed from the output.  After trial and error, the issue seems to be related to the number of rows fetched.

       

      My export settings:

       

      Format: delimited

      Delimiter: tab

      Line Terminator: environment default

      Left Enclosure: "

      Right Enclosure: "

       

      Other Preferences:

       

      Database > Advanced > Sql Array Fetch Size: 50

      Database > NLS > Date Format: DD-MON-YYYY HH24:MI:SS

       

      1. SUCCESS: Run SQL:

       

      SELECT last_ddl_time
      FROM dba_objects
      WHERE rownum <= 49
      

       

      RESULT:  The 49 rows copy into a text editor with the time stamps.  partial example below:

       

      10-FEB-2005 21:00:00

      10-FEB-2005 21:00:00

      ...

      21-MAY-2017 03:03:59

      19-AUG-2009 20:36:55

       

      2. FAIL: Run SQL:

       

      SELECT last_ddl_time
      FROM dba_objects
      WHERE rownum <= 50
      

       

      RESULT:  The 50 rows copy into a text editor WITHOUT the time stamps.  partial example below:

       

      10-FEB-2005 00:00:00

      10-FEB-2005 00:00:00

      ...

      21-MAY-2017 00:00:00

      19-AUG-2009 00:00:00

       

      3. Change Database > Advanced > Sql Array Fetch Size to "75"

       

      4.  SUCCESS: Run SQL:

       

      SELECT last_ddl_time
      FROM dba_objects
      WHERE rownum <= 74
      

       

      5. FAIL: Run SQL:

       

      SELECT last_ddl_time
      FROM dba_objects
      WHERE rownum <= 75
      

       

      6. SUCCESS: Run SQL, Ctrl-A to select all and Ctrl-C to Copy.

       

      SELECT last_ddl_time
      FROM dba_objects
      WHERE rownum <= 75
      

       

      7. SUCCESS: Run SQL, Ctrl-A to select All.  Right-click > Export

       

      This test previously failed.  The only thing i did differently was select all data to fetch the rows into the grid before calling the export function.

       

      SELECT last_ddl_time
      FROM dba_objects
      WHERE rownum <= 75
      

       

      Net result seems to indicate that when the export has to fetch data and then export, the timestamps are lost.  If the all data is already fetched to the grid, then the export would work.

       

      Thanks,

      Jason