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