Re: datetimeField = datetimeField - '30minutes'::timespan in psql 7.0 or above

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bangh <banghe(at)baileylink(dot)net>
Cc: Joel Burton <jburton(at)scw(dot)org>, Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: datetimeField = datetimeField - '30minutes'::timespan in psql 7.0 or above
Date: 2001-04-30 15:50:20
Message-ID: 15284.988645820@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

bangh <banghe(at)baileylink(dot)net> writes:
> while if you use type timestamp, instead of datetime
> timestampField = timestampField - '30minutes'::interval
> you will get error msg.:
> No such function 'datetime_stamp' with the specified attributes

I see no such problem in either 7.0 or 7.1 ...

regression=# create table foo1 (f1 timestamp);
CREATE
regression=# insert into foo1 values(now());
INSERT 832069 1
regression=# update foo1 set f1 = f1 - '30minutes'::interval;
UPDATE 1
regression=#

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Vecernik 2001-04-30 17:18:16 Re: disable wal
Previous Message Joel Burton 2001-04-30 15:35:56 Re: datetimeField = datetimeField - '30minutes'::timespan in psql 7.0 or above