Postgres Pro
Downloads
Home   >   mailing lists

Date_Part with time fields - Mailing list pgsql-novice

From Tim Mueller-Seydlitz
Subject Date_Part with time fields
Date
Msg-id 39E1AAEA.447E7941@nagler-consult.com
Whole thread Raw
List pgsql-novice
Tree view 
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:

Previous
From: ""
Date:
Subject: Simple Insert Function Syntax
Next
From: "Deniz Hastorun"
Date:
Subject: problem connecting with libpq++ interface