douxiuyi6529 2019-05-22 13:41
浏览 136

使用oracle数据库的Yii1 findByPk现在返回日期的其他格式

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

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 delta降尺度计算的一些细节,有偿
    • ¥15 Arduino红外遥控代码有问题
    • ¥15 数值计算离散正交多项式
    • ¥30 数值计算均差系数编程
    • ¥15 redis-full-check比较 两个集群的数据出错
    • ¥15 Matlab编程问题
    • ¥15 训练的多模态特征融合模型准确度很低怎么办
    • ¥15 kylin启动报错log4j类冲突
    • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大
    • ¥15 import arcpy出现importing _arcgisscripting 找不到相关程序