Skip to Main Content

APEX

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!

Timestamp in URL parameter

634676Dec 18 2009 — edited Jan 7 2010
Good afternoon,

I am trying to pass a value into another page which is used to pull up a record. The value is a date time stamp in the form of "DD-MON-YYYY HH24:MI:SS".

The value is in a report on page 1 and by clicking on an edit button I want to send the date value on that row into page 2.

I have used the formatting in my parameters of :P2_DATE_TIME_STAMP,\#DATE_TIME_STAMP#\

Unfortunately I get results showing day, month, year, hour, and minute but excluding the second, for example "18-DEC-2009 13:53" showing up in my second page and get a data not found error when the pre-page process tries to look up the record.

Why is it not sending the seconds as well and is there a way around this?

Please advise,
Adam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2010
Added on Dec 18 2009
6 comments
2,723 views