Subject Re: [firebird-support] Timestamp conversion issue
Author Mark Rotteveel
On 2016-04-05 10:47, Alex Castillo acr_korn@...
[firebird-support] wrote:
> Hello everyone,
> I'm having some issues with a stored procedure. This is a legacy
> development, so the time was stored in a varchar field and the date
> in
> a timestamp field.
> The issue stills happens after the upgrade from 2.1.5 to 2.1.7 on
> linux open suse 11.4 x64, classic engine. However, this is not
> happening on my development machine using Windows XP. Even on my
> development environment I've restored the database to 2.1.5 using
> classic and super, but the issue is not being reproduced there, It
> seems to be a linux specific issue. In both cases I'm using
> FlameRobin
> as client.

Could you show a sample of the time values? As far as I know Firebird
use platform specific time conversion functions. This means that
non-SQL-standard formats can fail or succeed depending on the platform
(and maybe regional settings).