Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Converting timestamp format to CCYY-MM-DD-HH.MM.SS.LLLLLL format

TinaMar 23 2018 — edited Mar 23 2018

Hi there,

I need some help converting timestamp format.

I have a table which stores a timestamp as character (we are loading it from a file in staging table),and current format is

'YYYY-MM-HH.MM.SS.LLLLLL'  or 2018-02-13-04.06.00.000000.

Is there a way to convert this string into default timestamp format or even a standard date format?
This post has been answered by Tina on Mar 23 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2018
Added on Mar 23 2018
#general-database-discussions
2 comments
1,269 views