Skip to Main Content

Oracle Forms

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!

format date in oracle form

Tony007Mar 14 2016 — edited Mar 14 2016

hi am formatting date calling report

I what to display sysdate with time how can I do that I try this

Add_parameter(pl_id, 'P_DTE_TME_STAMP', TEXT_PARAMETER, to_date(:block.field,'YYYYMMDDHH24MISS'));

Add_parameter(pl_id, 'P_DTE_TME_STAMP', TEXT_PARAMETER, to_date(:block.field,'YYYY/MM/DD HH24:MI'));

Captureformatdate.PNG

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2016
Added on Mar 14 2016
4 comments
3,494 views