I am having an issue with oracle 11g and yii 1.1 when retrieving dates:
I am having an initSQL as follows:
"ALTER SESSION SET NLS_DATE_FORMAT='dd-mm-yyyy hh24:mi:ss'",
'ALTER SESSION SET NLS_COMP=ANSI',
'ALTER SESSION SET NLS_COMP=LINGUISTIC',
'ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER',
'ALTER SESSION SET NLS_SORT=BINARY_AI',
but when the application returns a date through a findByPk() for example it returns it in 'dd-MMM-yy' format for example 25-MAY-19, this happened when changing from one server to another but connecting to the same database, but right now I am unable to find which config param is causing this. Any Ideas