Return
-
Title
Sysdate does not display correctly in Toad for Oracle after changing NLS_CALENDAR parameter -
Description
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 DUAL13 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 DUAL03.03.2009 3:13:11 PM
This is not the expected result.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.