App engine sqlexec default date format. How to check or modify?
edited Jun 19, 2015 10:03AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered
Hi,
Could you please help me to idenfity where the default date format is set in Peoplesoft? My actual requirement is to identify where default date format is set in the environment.
Same application engine program gives the output in different formats in different environments.
It is just a SQLExec to fetch date from table
select date from table1
Environment 1 gives output in "YYYY-MM-DD" format.
Environment 2 gives output in "MM/DD/YYYY" format.
while i run the query directly in DB using "sqlplus", the output is in the same format in both environment. So I assume it is due to some setting there in Peoplesoft Level. Could any of you help me with this.
0