TOraLoader: problems with TDateTime

Maep · Post by **Maep** » Fri 20 Jan 2006 08:21

Hello guys!
That's a question..

I use TOraLoader (ODAC 5.50.19) to load data into oracle (isn't it funny?)
So, i have Date field in my table and TDateTime variable in my Delphi 7 programm.
OraSession.DateFormat is 'DD.MM.RRRR HH:MI:SS' ( 'DD.MM.YYYY HH:MI:SS' tried).
After upload date in oracle table is truncated (DD.MM.YYYY 00:00:00), that

I tried two ways:
Sender.PutColumnData(mCol, mRow, );
Sender.PutColumnData(mCol, mRow, );
Both useless.

What was the next step:
I changed DateFormat properties for OraLoader and Columns to
'dd.mm.yyyy hh24:mi:ss'
It works as hh12 format: I mean, if i try to insert date whith hout not between 1 and 12, a get ORA-01849 error (hour must be between 1 and 12).
What's wrong with date formats?
Thank you!

Challenger · Post by **Challenger** » Fri 20 Jan 2006 14:53

We couldn't reproduce your problem. Please specify correct version of ODAC you use (we have no such version) and send small demo project to ODAC support address including script to create server objects.