Hi Guyz, does anyone tried to INSERT records from Text File to Oracle database with TIMESTAMP Fields?
For Example, in text file I have
'2006-08-09 09:03:30.97' data, when I run Clover, on 09/08/2006 are saved in the database, the time is remove.anyone has an Idea?
Thankl You very much.
For Example, in text file I have
'2006-08-09 09:03:30.97' data, when I run Clover, on 09/08/2006 are saved in the database, the time is remove.anyone has an Idea?
Thankl You very much.
-
Hi, do you have filled a format field? Maybe this is problem, default value is yyyy-MM-dd.
<Metadata id="Metadata0">
<Record name="ExampleRecord" recordDelimiter="" recordSize="-1" type="delimited">
<Field delimiter="\n" name="Field0" nullable="false" shift="0" format="yyyy-MM-dd HH:mm:ss.SS" type="date"/>
</Record>
</Metadata>
Please sign in to leave a comment.
Comments 1