From: | "HINKLEY,DUANE (Non-HP-Boise,ex1)" <duane_hinkley(at)nonhp-am(dot)exch(dot)hp(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Simple time math with " No such function 'time_timespan' with the specified attributes " error |
Date: | 1999-10-18 21:56:13 |
Message-ID: | 2FABBD0C77DAD211971F00A0C9DEFC332E1959@xboi04.boi.hp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm doing a billing system and trying to get postgresql to calculate the
difference in time. Every way I do it I get an error with the time_timespan
function.
Here's an example:
billsys=> select stoptime - starttime from jobdetail;
ERROR: No such function 'time_timespan' with the specified attributes
Here's the data:
id|number | date|starttime|stoptime|duration|description
--+--------+----------+---------+--------+--------+----------------
1|1175 |09-09-1999|10:30:00 |11:30:00| |test
billsys=> \d jobdetail
Table = jobdetail
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| id | int4 not null default nextval('" |
4 |
| number | char() |
8 |
| date | date |
4 |
| starttime | time |
8 |
| stoptime | time |
8 |
| duration | timespan |
12 |
| description | char() |
100 |
+----------------------------------+----------------------------------+-----
--+
Index: jobdetail_id_key
From | Date | Subject | |
---|---|---|---|
Next Message | searchers | 1999-10-18 22:26:56 | Your Web Page |
Previous Message | Carsten Huettl | 1999-10-18 21:10:51 | (Fwd) Re: ld.so failed |