Обсуждение: BUG #9897: Wrong Julian Date through ODBC

The following bug has been logged on the website:

Bug reference:      9897
Logged by:          Georg Klimm
Email address:      klimm@lohn24.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

first is 2013-10-31 and second the correct 2014-03-26

same with 2014-03-27 or all other dates is working

On Mon, Apr  7, 2014 at 06:09:53PM +0000, klimm@lohn24.de wrote:
> The following bug has been logged on the website:
>
> Bug reference:      9897
> Logged by:          Georg Klimm
> Email address:      klimm@lohn24.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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

On Wed, Apr 9, 2014 at 7:02 PM, Bruce Momjian <bruce@momjian.us> wrote:
> On Mon, Apr  7, 2014 at 06:09:53PM +0000, klimm@lohn24.de wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference:      9897
>> Logged by:          Georg Klimm
>> Email address:      klimm@lohn24.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)
Georg is mentioning ODBC in the subject. If it could be possible to
get the code sample used with it it would be nice. Perhaps this is
simply a driver issue.
--
Michael

I just found the problem:

The returned data was converted from 8859-1 to cp850 without caring about t=
he data types :(


----------------urspr=C3=BCngliche Nachricht-----------------
Von: Bruce Momjian [bruce@momjian.us ]
An: klimm@lohn24.de
Kopie: pgsql-bugs@postgresql.org
Datum: Wed, 9 Apr 2014 06:02:22 -0400
-------------------------------------------------


> On Mon, Apr 7, 2014 at 06:09:53PM +0000, klimm@lohn24.de wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 9897
>> Logged by: Georg Klimm
>> Email address: klimm@lohn24.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=3D> 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 untersuch=
t.
>
>

The BASIS Company checks if it is a problem in the Interpreter.

In Delphi we cannot reproduce the error via ODBC
In Business Basic the date was represented as a 4-byte Julian date with the=
 reported error.

I will report if I have new findings

----------------urspr=C3=BCngliche Nachricht-----------------
Von: Bruce Momjian [bruce@momjian.us ]
An: klimm@lohn24.de
Kopie: pgsql-bugs@postgresql.org
Datum: Wed, 9 Apr 2014 06:02:22 -0400
-------------------------------------------------


> On Mon, Apr 7, 2014 at 06:09:53PM +0000, klimm@lohn24.de wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 9897
>> Logged by: Georg Klimm
>> Email address: klimm@lohn24.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=3D> 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 untersuch=
t.
>
>