Syntax for milliseconds in DATE field in an external table
529670Feb 7 2007 — edited Feb 7 2007I 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.