Subject Re: [firebird-support] Timestamp conversion issue
Author Mark Rotteveel
On 2016-04-07 5:26, Alex Castillo acr_korn@... [firebird-support]
> I've no doubt this is a bug for the linux release. It should be
> filtering the string literals before doing the conversion as it does
> on Windows.

I don't think it is a bug. Firebird supports the SQL standard
ISO-8601(-ish) format for date and time, and in addition it supports a
number of conversions that are supported by the platform (and may depend
on regional settings). This means that except for the format mandated by
the SQL standard, you shouldn't expect anything else (and everything
else that does work is nice to have).

The format in your initial question BTW as "10:00:00 a.m. ", even on
Windows I suspect this will fail if your locale is set to a 24 hour
clock (but I haven't tried).

> The way I've solved was by creating a global temporary table and
> copying the values from a view, converting the varchar to time. So
> now, when I perform DATA + TIME = TIMESTAMP in a right way. This is
> not optimal, but it does work meantime the issue can be evaluated by
> the firebird team.

Did you create a ticket in the tracker? Otherwise nothing is going to