Date problem

From: "Edipo E(dot) F(dot) Melo" <edipoelder(at)ig(dot)com(dot)br>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Date problem
Date: 2000-09-29 02:05:03
Message-ID: 200009290207.e8T27Bp59335@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2000-09-29 05:41:15 Re: Date problem
Previous Message Carolyn Wong 2000-09-29 00:19:59 Re: memory usage