FAQ
In 7.1.3 I can use

select timestamp(date '2001-01-01', time '00:00');

but in 7.2.4 I get

db1=# select timestamp(date '2001-01-01', time '00:00');
ERROR: parser: parse error at or near "date"

I get the same error when using actual columns in actual tables. Both
PostgreSQL versions are compiled from source on a Intel Linux box.

Search Discussions

  • Ian Barwick at Jun 26, 2003 at 11:05 pm

    On Friday 27 June 2003 00:47, Holger Marzen wrote:
    In 7.1.3 I can use

    select timestamp(date '2001-01-01', time '00:00');

    but in 7.2.4 I get

    db1=# select timestamp(date '2001-01-01', time '00:00');
    ERROR: parser: parse error at or near "date"
    changed in 7.2, see:
    http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=release-7-2.html

    "The timestamp(), time(), and interval() functions are no longer available.
    Instead of timestamp(), use timestamp 'string' or CAST. "

    -> something like:
    select timestamp '2001-01-01 00:00';
    should work


    Ian Barwick
    barwick@gmx.net
  • Stephan Szabo at Jun 26, 2003 at 11:12 pm

    On Fri, 27 Jun 2003, Holger Marzen wrote:

    In 7.1.3 I can use

    select timestamp(date '2001-01-01', time '00:00');

    but in 7.2.4 I get

    db1=# select timestamp(date '2001-01-01', time '00:00');
    ERROR: parser: parse error at or near "date"
    To be closer to the standard, timestamp() became a reference to the
    datatype with a given precision (given in the parens). You can still get
    at the functions with "timestamp"(...), but I think you can also use
    date '2001-01-01' + time '00:00' as well.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJun 26, '03 at 10:50p
activeJun 26, '03 at 11:12p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase