Re: parse error in timestamp function

From: "Marek" <marek(at)nogi(dot)risk(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: parse error in timestamp function
Date: 2002-02-18 14:54:25
Message-ID: a4r4a5$dj$1@news.tpi.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

no its not a bug.
following HISTORY file:
"The timestamp() function is no longer available. Use timestamp 'string'
instead, or CAST"
for exapmle
select timestamp '2002-02-14'
timestamptz
--------------------
2002-02-14 00:00:00+01

marek

Uzytkownik "Bart Teeuwisse" <bart-postgres(at)7-sisters(dot)com> napisal w
wiadomosci news:3C705FD0(dot)7080508(at)7-sisters(dot)com(dot)(dot)(dot)
> The following examples from 4.8. Date/Time Functions and Operators fail
> with parse errors in PG 7.2:
>
> select timestamp(date '2000-12-25');
> ERROR: parser: parse error at or near "date"
>
> select timestamp(date '1998-02-24',time '23:07');
> ERROR: parser: parse error at or near "date"
>
> The same examples do work in PG 7.1.3.
>
> Is this a bug?
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leif Jensen 2002-02-18 14:55:11 Re: psql & HTML
Previous Message Bruce Momjian 2002-02-18 14:52:19 Re: IN optimization in 7.2 ?????