From: Edipo E. F. Melo <edipoelder@ig.com.br>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Date problem
Date: Thu, 28 Sep 2000 23:05:03 -0300 (ADT)
Message-ID: <200009290207.e8T27Bp59335@hub.org> (raw)
In-Reply-To: <web-1093339@davinci.ethosmedia.com>
Hi all,
Hi all,
Before all, a little (off-topic) comment:
>It's been my experience that Win32 ODBC does not drop
>connections until the database client is closed (e.g. MS
>Access is shut down).
"There is some things that only Micro$oft can do for you..."
Ok. Let's work. I posted a mail before explaining a strange
cituation if my Postgresql: when I use date_part() function to split
day, month and year of a date type column, it returns one day before.
In other words, '2000-01-01' returns day: 31, month:12, year: 1999.
I'm using OS/2 with Fix Pack 12, Postgresql 7.0.2.
Can any one explain this?
[]'s
Edipo Elder F. de Melo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: edipoelder@ig.com.br
Subject: Re: Date problem
In-Reply-To: <200009290207.e8T27Bp59335@hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox