Message-ID: <39D42B7B.800F2870@agliodbs.com>
Date: Thu, 28 Sep 2000 22:41:15 -0700
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
MIME-Version: 1.0
To: sqllist <pgsql-sql@postgresql.org>
Subject: Re: Date problem
References: <200009290207.e8T27Bp59335@hub.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Elipo,

>         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.

	No, I was hoping an expert would take this on.  Lemme test it on Linux:

create table test_date AS (
	haveadate DATE );

insert into test_date ( haveadate )
	values ( '2000-04-30' );

select haveadate, date_part('month',haveadate),
date_part('day',haveadate),
	date_part('year',haveadate) from test_date

haveadate	
2000-04-30	4	30	2000

No problem here.  Or on PG-ACCESS.  

The problem must be in the OS/2 compile, probably some problem in
accessing the internal clock?

					-Josh

-- 
______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology      josh@agliodbs.com
    and data management solutions       (415) 436-9166
   for law firms, small businesses       fax  436-0137
    and non-profit organizations.       pager 338-4078
                        		San Francisco