Skip to Main Content

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PeopleSoft date format

703034Jul 28 2009 — edited Jul 28 2009
I wanted to know where do we define or set the default peoplesoft format at the application server level? E.g. currently

if we use *%datein(effdt)* in application engine, it resolves to

to_date(to_char(effdt), ‘YYYY-MM-DD’)


Is there a way where I can change some setting so that this resolves to

to_date(to_char(effdt), ‘YYYYMMDD’)



Thanks,
Vikas

Comments

Kgronau-Oracle
To see which ODBC function DG4ODBC is looking for and unixODBC isn't supporting it would be best to get an ODBC trace file. But as your unixODBC driver (unixODBC-2.2.11-10.el5) is outdated and these old drivers had a lot of issues when being used on 64bit operating systems (for example wrong sizeofint etc). So best would be to update the unixODBC Driver manager to release 2.3.x. More details can be found on the web site: www.unicodbc.org


- Klaus
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 25 2009
Added on Jul 28 2009
10 comments
5,926 views