Home > mailing lists

a date_part question - Mailing list pgsql-general

From	Tony Grant
Subject	a date_part question
Date	March 5, 2003 13:00:51
Msg-id	1046898410.2942.9.camel@localhost Whole thread Raw
Responses	Re: a date_part question (Richard Huxton <dev@archonet.com>)
List	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

From: David Ecker
Date: 05 March 2003, 12:58:25
Subject: Restriction on transaction size????

From: Tom Lane
Date: 05 March 2003, 13:04:05
Subject: Re: Help with select into