On 2016-04-07 5:26, Alex Castillo acr_korn@yahoo.com [firebird-support]
wrote:
> 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
happen.
Mark
Posted by: Mark Rotteveel <mark@lawinegevaar.nl>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment