7.2b Timestamp

From: Dave Smith <dave(at)candata(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.2b Timestamp
Date: 2001-11-14 20:08:44
Message-ID: 3BF2CF4C.1080304@candata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Has some thing changed with the timestamp function since 7.0

7.0
create table t (i int);
insert into t values(1);
select timestamp(date '1998-02-24', time '23:07') from t;
timestamp
------------------------
1998-02-24 23:07:00-05
(1 row)

7.2 b
create table t (i int);
insert into t values(1);
select timestamp(date '1998-02-24', time '23:07') from t;
ERROR: parser: parse error at or near "date"

I'm asuming it changed in 7.2 because the 7.1 docs show the usage the
same as 7.0 (or the docs are wrong ;-) )

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ned Lilly 2001-11-14 21:28:17 Re: Sourceforge on Oracle?
Previous Message Brent Verner 2001-11-14 20:00:32 where can I get mailing list archives in mbox format?