Обсуждение: 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. > >