Skip to Main Content
Forums

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!

need to change date format to binary format

ramanlakundeJan 5 2010 — edited Jan 6 2010
I have date as '01-JAN-2010' but i need to insert as binary format .
how can i give insert statement ?

desc temp;
proc_date number 9

insert into temp(proc_date) values (date in binarydateformat );



if there is any way
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2010
Added on Jan 5 2010
4 comments
1,731 views