From: | "Georg Klimm Lohn24(dot)de ila GmbH" <klimm(at)lohn24(dot)de> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | "pgsql-bugs postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #9897: Wrong Julian Date through ODBC |
Date: | 2014-04-09 10:46:11 |
Message-ID: | d8a9ad23f6ae2f443206d36d73b59656@intranet.lohn24.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I just found the problem:
The returned data was converted from 8859-1 to cp850 without caring about the data types :(
----------------ursprüngliche Nachricht-----------------
Von: Bruce Momjian [bruce(at)momjian(dot)us ]
An: klimm(at)lohn24(dot)de
Kopie: pgsql-bugs(at)postgresql(dot)org
Datum: Wed, 9 Apr 2014 06:02:22 -0400
-------------------------------------------------
> On Mon, Apr 7, 2014 at 06:09:53PM +0000, klimm(at)lohn24(dot)de wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 9897
>> Logged by: Georg Klimm
>> Email address: klimm(at)lohn24(dot)de
>> PostgreSQL version: 8.4.20
>> Operating system: Server @ LINUX, Client @ WIndows
>> Description:
>>
>> SELECT '2014-03-26'::DATE AS date1, '2014-03-26'::DATE AS date2
>>
>> returns 2456597 2456743
>
> I don't understand these return values.
>
>> first is 2013-10-31 and second the correct 2014-03-26
>>
>> same with 2014-03-27 or all other dates is working
>
> I cannot reproduce that failure here:
>
> test=> SELECT '2014-03-26'::DATE AS date1, '2014-03-26'::DATE AS date2;
> date1 | date2
> ------------+------------
> 2014-03-26 | 2014-03-26
> (1 row)
>
> --
> Bruce Momjian
http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>
>
> --
> Diese Nachricht wurde auf Viren und andere gefaehrliche Inhalte untersucht.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2014-04-09 10:54:21 | Re: cannot to set track_activity_query_size in kB |
Previous Message | Georg Klimm Lohn24.de ila GmbH | 2014-04-09 10:12:52 | Re: BUG #9897: Wrong Julian Date through ODBC |