Hi,

I'm trying to load a plain archive (txt) to an Oracle table with SQL Loader, but we are having problems when the field is a Date + time. Only Date gets saved into the field of the table, ignoring the time included.

When creating the archive the date + time field is saved converting it with a TOCHAR.

Any suggestions will be welcomed.

Thank u all in advance!

you can set a format mask for the date ..
dd-mm-rrrr hh24:mi:ss

Have you tried that :?:

commented: Good answer and Happy New Year +6

Thnx, that worked for me

:)

np .. :icon_mrgreen:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.