timestamp in 7.2

From: mark(at)vestnesis(dot)lv
To: pgsql-admin(at)postgresql(dot)org
Subject: timestamp in 7.2
Date: 2002-03-27 10:55:54
Message-ID: 3CA1C15A.29615.58FACD5@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all.

I'v migrated my data to 7.2.
Now I'm testing aplications, but looks like timestamp function in
postgres is broken:
klienti=# select date(now());
date
------------
2002-03-27
(1 row)

klienti=# select timestamp(date(now()));
ERROR: parser: parse error at or near "date"

I need to make querys with timestamp(date,time);
But timestamp don't work even with sample from manual:

klienti=# select timestamp(date '1998-02-24',time '23:07');
ERROR: parser: parse error at or near "date"

Mark

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Karel Zak 2002-03-27 11:07:06 Re: timestamp in 7.2
Previous Message Martins.Zarins 2002-03-27 10:41:47 timestamp function in 7.2