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!

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.

Syntax for milliseconds in DATE field in an external table

529670Feb 7 2007 — edited Feb 7 2007

I can't figure it out.

I've got one field that is formatted down to the second and this works:
dtg_update char date_format date mask "MM/DD/YY HH24:MI:SS"

But I've got another field that is down to the millisecond: 2/7/2007 12:01:04.891

Using:
change_date char date_format date mask "MM/DD/YY HH24:MI:SS.FF3"
or various combinations thereof doesn't seem to work. When I select from the external table I get date conversion errors.

What's the appropriate format for milliseconds?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2007

Added on Feb 7 2007

4 comments

79,104 views