Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to Cast VARCHAR2 to TIMESTAMP(6) In Select Statement In Oracle?

Posted on 2014-11-23
1
Medium Priority
?
534 Views
Last Modified: 2014-11-23
Dear Experts,

I have a table with a field varchar2(24) with values like: '2012-09-27 01:40:31.0' (I think trailing spaces exist as well)

I want to perform insert into table select that field but the corresponding field in the target table is type TIMESTAMP(6)

How can I achieve this?

BR
0
Comment
Question by:GurcanK
1 Comment
 
LVL 35

Accepted Solution

by:
johnsone earned 2000 total points
ID: 40460567
You just need to include a to_timestamp function on the character field.

insert into mytab (col1) select to_timestamp(col2, 'yyyy-mm-dd hh24:mi:ss.ff') from mytab;

If for any reason a value is not in that specific format, you will get an error.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses
Course of the Month14 days, 16 hours left to enroll

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question