Date_Part with time fields

From: Tim Mueller-Seydlitz <Tim(dot)Mueller-Seydlitz(at)Nagler-Consult(dot)COM>
To: pgsql-novice(at)postgresql(dot)org
Subject: Date_Part with time fields
Date: 2000-10-09 11:24:26
Message-ID: 39E1AAEA.447E7941@nagler-consult.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi there,
I am trying to get Date_Part to work with time fields. As it seems this
is not working:
select date_part('hr',t.from) from times t;
ERROR: No such function 'time_timespan' with the specified attributes

Any comment?

I am using [PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc
egcs-2.91.66]

Regards
Tim Mueller-Seydlitz

Browse pgsql-novice by date

  From Date Subject
Next Message Greger Haga 2000-10-10 02:45:39 Re: Thanks...and then the question:Architecture.
Previous Message Deniz Hastorun 2000-10-09 08:33:49 problem connecting with libpq++ interface