The sysdate (select sysdate from dual) does not display correctly in Toad for Oracle after changing NLS_CALENDAR parameter.
1. In SQLPlus, run
ALTER SESSION SET NLS_CALENDAR=PERSIAN
SELECT SYSDATE FROM DUAL
13 Esfand 1387
This is the expected result.
2. In the Editor on Toad for Oracle, run
ALTER SESSION SET NLS_CALENDAR=PERSIAN
SELECT SYSDATE FROM DUAL
03.03.2009 3:13:11 PM
This is not the expected result.
WORKAROUND #1:
Use this SQL statement instead "select to_char(sysdate,'dd-month-yyyy') from dual"
WORKAROUND #2:
Use F5 or Execute as Script command
STATUS:
Waiting for a fix in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center