On 2016-04-05 10:47, Alex Castillo acr_korn@yahoo.com
[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).
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 (2) |
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