Subject | Date/Time string conversion utility function? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2015-12-08T12:55:39Z |
Hello Jason,
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?
Thanks!
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
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?
Thanks!
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.