E-AE/DB: Can NLS_DATE_FORMAT Be Changed in an Application Engine Program? (Doc ID 1575465.1)

Last updated on APRIL 04, 2025

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.

PT 8.50

Oracle database

A customized Application Engine (AE) program used the SQL below to change the date format;

This is caused problems to another Application Engine program that ran later and processed date value.

Can date format be changed on an AE program? If yes, what is the proper way to change it?

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.