Re: Date problem

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