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!

Hour with sysdate

449068Nov 3 2005 — edited Nov 3 2005
Hi,
I have a problem with the sysdate : I would like to return date + hour, like this :
"update transporte set heuretelservice = to_date(sysdate,'dd/mm/yy hh:mi') where numbon = :P7_NUMBON;
commit;"
But it return only te date ...

I execute this process through a button.

Thanks for help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2005
Added on Nov 3 2005
4 comments
810 views