Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group