I don't know how this got to me when it was sent to
[EMAIL PROTECTED], but anyway here's the answer:
psql -U postgres template1
On Sun, 20 May 2001, Subhramanya Shiva wrote:
> Hi all
>
> I installed postgresql successfully.
> But when i starting the server it is showing the server status diff
Or you could use date_trunc() in the same way as date_part() if you want
an interval instead..
SELECT date_trunc('year',age(birth)),* FROM persons LIMIT 1;
On Fri, 18 May 2001, [EMAIL PROTECTED] wrote:
> You are probably looking for date_part().
>
> E.g.
>
> SELECT date_part('year',age(birt
There appears to be a bug in timestamp/interval addition. It happens in
both PG version 7.0.2 and 7.1. There is a duplicate day (2001 Sep 07) and
a missing day (2002 Apr 04). I discovered this by accident when I asked
the interface I'm writing for a 365 day long calendar.. Interestingly,
the
