a date_part question

From: Tony Grant <tony(at)tgds(dot)net>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: a date_part question
Date: 2003-03-05 21:06:51
Message-ID: 1046898410.2942.9.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Why is date_part('year', timestamp) returning 1988.0?

timestamp is a timestampz field in the table.

Postgresql 7.3

Cheers

Tony Grant

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tariq Muhammad 2003-03-05 21:09:12 Re: accessing two databases at the same time
Previous Message Ian Barwick 2003-03-05 20:54:43 Re: accessing two databases at the same time