Re: Time intervals in select statement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luke McFarlane <luke(at)fisheye(dot)com(dot)au>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Time intervals in select statement
Date: 2004-10-19 07:16:35
Message-ID: 12694.1098170195@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Luke McFarlane <luke(at)fisheye(dot)com(dot)au> writes:
> SELECT create_time, create_time - '8 days 16:49:22.600601' FROM foo;

> ERROR: invalid input syntax for type timestamp: "8 days 16:49:22.600601"

Cast the constant to interval explicitly.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Luke McFarlane 2004-10-19 07:22:11 Re: Time intervals in select statement
Previous Message Luke McFarlane 2004-10-19 07:05:04 Time intervals in select statement