Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group