Member Avatar for elferra

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!

  • 2 Contributors
  • 3 Replies
  • 83 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Sulley's Boo
Member Avatar for Sulley's Boo

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
Member Avatar for elferra

Thnx, that worked for me

:)

Member Avatar for Sulley's Boo

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.