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!

How to convert varchar to timestamp

Srikkanth.MMar 11 2010 — edited Mar 11 2010
Hai All

How to convert varchar to timestamp datatype

I have four timing 0800,1200,1300,1700 this data are stored in one table called T1 and varchar datatype

And i need to move these data to another table T2 in that four column intime,intrin,introut,outtime are declared as date or timestamp i need to move those timing to this table how can i convert this and move to table T2


how can i convert this time to date or timestamp

Thanks & Regards

Srikkanth.M
This post has been answered by Prazy on Mar 11 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2010
Added on Mar 11 2010
7 comments
10,759 views