Watch, Follow, &
Connect with Us

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

Welcome, Guest
Guest Settings

Thread: Oracle timestamp with local timezone

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

Permlink Replies: 0
Markus Donath

Posts: 16
Registered: 3/27/06
Oracle timestamp with local timezone  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 23, 2017 6:27 AM
I want so get the values from an Oracle table with a column defined as 'Oracle timestamp with local timezone' .
I use a TFDQuery to select the values. If I set para's DataType to 'ftOraTimeStamp' I get:

[FireDAC][Phys][ID_Ora]-336. Parameter [DTV] data type is not supported

If I use 'ftTimeStamp' instead, I don't know how to get along the correct values to the parameters in the WHERE clause.

Any ideas how to deal with this Oracle field type?

Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02