Re: [SQL] `statistical' aggregate functions etc.

On Mon, 19 Oct 1998, Ulf Mehlig wrote:

> 
> I'm a novice to postgresql, so please excuse if I'm addressing to the
> wrong mailing list!
> 

.....
> 
> Other question: I'm used to use DB2/2, and DB2/2 has functions like
> "month(some_date)" and "hour(some_timestamp)". Are there equivalents
> in postgresql?
> 

I think you should try date_part function, which is described in
pgintro(1) man page:
	select date_part('month', some_date);