Hello Thomas,

Wednesday, December 9, 2015, 1:55:39 AM, you wrote:

> I have to deal with date/time information in a database implicitly
> casted and stored in a VARCHAR field, thus depending on the database
> dialect, I end up with something like that. For example:

> Dialect 1: 7-DEC-2015 20:29:12.3820
> Dialect 3: 2015-12-07 20:31:07.2280

> I have to process that strings as TDateTime in an IBO based Delphi
> application later on, independent of the local regional settings the
> Delphi application is running on.

> Does IBO have some sort of utility function supporting various "native"
> date/time string representations of InterBase/Firebird, where the result
> is of type TDateTime?

Is there some reason why you can't bring the string into the dataset
as a timestamp directly in a run-time field, using a short cast?
e.g.
select ....,
timestamp (TheStringField) as aTimestamp,
...

Firebird (and, AFAIR, IB) accepts a huge variety of date/time strings
as valid, including the two examples here.

Helen