Postgres Pro
Downloads
Home   >   mailing lists

Re: Time intervals in select statement - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Time intervals in select statement
Date
Msg-id 12694.1098170195@sss.pgh.pa.us
Whole thread Raw
In response to Time intervals in select statement  (Luke McFarlane <luke@fisheye.com.au>)
Responses Re: Time intervals in select statement  (Luke McFarlane <luke@fisheye.com.au>)
List pgsql-bugs
Tree view 
Luke McFarlane <luke@fisheye.com.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

pgsql-bugs by date:

Previous
From: Luke McFarlane
Date:
Subject: Time intervals in select statement
Next
From: Luke McFarlane
Date:
Subject: Re: Time intervals in select statement