Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: DateTime miliseconds difference


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Feb 16, 2018 6:22 PM Last Post By: Ted Lyngmo Threads: [ Previous | Next ]
Jayme Jeffman

Posts: 20
Registered: 3/2/98
DateTime miliseconds difference  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 15, 2018 5:41 AM
Hello,

Is there any known issue on converting DateTime values from MSSQL and Oracle ?

I am getting different miliseconds values when importing datetime values from MSSQL to Oracle.

I am using TAdoQuery and Devart ODAC components on C++Builder 6.0 Professional edition.

Thank you very much.

Best regards.

Jayme Jeffman
Ted Lyngmo

Posts: 117
Registered: 10/3/06
Re: DateTime miliseconds difference  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 16, 2018 6:22 PM   in response to: Jayme Jeffman in response to: Jayme Jeffman
Jayme Jeffman wrote:

Is there any known issue on converting DateTime values from MSSQL and Oracle ?
I am getting different miliseconds values when importing datetime values from MSSQL to Oracle.
I am using TAdoQuery and Devart ODAC components on C++Builder 6.0 Professional edition.

The precision isn't really in there. You'll have to decide how accurate you need it to be - and how accurate were those times when first recorded?
If you cut a millisecond or 123.5 off, will it ruin the day? If that's the case - you need more info!

Br,
Ted
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02