We are migrating from Oracle database and applications(OCI aplications) to DB2 V10 (under Linux).
Our applications include "alter session set NLS_TIMESTAMP_FORMAT = 'YYYYMMDD HH:MT:SS" and "alter session set NLS_TIMESTAMP_T2_FORMAT = 'YYYY/MM/DD HH24:MT:SS" statements. We would like to use diffrent timestamp format each session.
How should we modify our applications?
Thank you for your advice in advance.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
2 replies Latest Post - 2013-03-22T08:25:38Z by juchin
Pinned topic alter session set NLS_TIMESTAMP_FORMAT (migrating from Oracle)
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-22T08:25:38Z at 2013-03-22T08:25:38Z by juchin
nivanov1 100000H9H722 PostsACCEPTED ANSWER
Re: alter session set NLS_TIMESTAMP_FORMAT (migrating from Oracle)2013-03-15T15:13:24Z in response to juchinYou cannot change the way DB2 formats datetime values, apart from using TIMESTAMP_FORMAT() or TO_CHAR(). The server NLS settings will be in effect otherwise. In my view, it's the application client responsibility to format data according to the users' preferences.
juchin 270002FA078 Posts