Postgres Pro
Downloads
Home   >   mailing lists

Thread: timestamp in 7.2

timestamp in 7.2

From
mark@vestnesis.lv
Date:
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

Re: timestamp in 7.2

From
Karel Zak
Date:
On Wed, Mar 27, 2002 at 12:55:54PM +0200, mark@vestnesis.lv wrote:
> 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 thing better is use some cast method instead cast by function call:

test=# SELECT CAST( now() AS date ), now()::date, 'now'::date::timestamp;
    now     |    now     |      timestamptz
------------+------------+------------------------
 2002-03-27 | 2002-03-27 | 2002-03-27 00:00:00+01
(1 row)


>
> 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"

test=# select date '1998-02-24' + time '23:07';
      ?column?
---------------------
 1998-02-24 23:07:00
(1 row)

test=# select timestamp '1998-02-24 23:07';
      timestamptz
------------------------
 1998-02-24 23:07:00+01
(1 row)


    Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

Re: timestamp in 7.2

From
Stephan Szabo
Date:
On Wed, 27 Mar 2002 mark@vestnesis.lv wrote:

> 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"

timestamp is more reserved than before, I believe it'll work as
"timestamp"(...).  The other form is now for specifying the precision
of a timestamp.