SQL & PL/SQL

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 to a string

user11092973Oct 29 2015 — edited Oct 29 2015

Hi there,

I have a column on a table that is as following:

v_deadline varchar2(10);

The data on the column is 11:15:00. From Oracle forms I am sending this to a package as '11:15:00'.

How do I do this? I can't seem to convert 11:15:00 to '11:15:00'? This is actually a time hh24:mi:ss

Since it is a database column value SQL seems to think that this is bind variable.

Any suggestions much appreciated.

Thx,

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2015

Added on Oct 29 2015

7 comments

1,284 views