After executing this query:
Select sysdate, trunc(sysdate) from dual;
The options for exporting to Excel File / Excel instance have a different behavior with Date masks.
--------
TDP Data: 13/03/2014 13:18:57 13/03/2014 00:00:00
DD/MM/YYYY
Exporting to Excel File:
SYSDATE TRUNC(SYSDATE)
03/13/2014 03/13/2014
-->>MM/DD/YYYY<<--
Exporting to Excel Instance:
DD/MM/YYYY
13/03/2014
SYSDATE TRUNC(SYSDATE)
####################
WORKAROUND:
Use English Windows regional settings.
STATUS:
Waiting for fix in a future release of Toad Data Point
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center