PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

SQLExec Updating Timestamp - Time is being defaulted to 12:00 AM instead of using value

edited Jun 13, 2014 2:16PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 7 commentsAnswered

Hello,

I have created an App Engine and need to update a time field using the date from another field and the time that was uploaded to the time field however when the SQLExec Update is ran, the time value is defaulting to 12:00 AM in the table.  I have copied my coded that I am using and also the trace file showing the values below.  The value that is being shown on the table is 24-AUG-10 12.00.00.000000 AM.  How can I fix my code to not have the 12:00 AM time default and actually update the table correctly?  Any help

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center