From: | "Frank Church" <voipfc(at)googlemail(dot)com> |
---|---|
To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Syntax for converting double to a timestamp |
Date: | 2006-09-04 00:11:14 |
Message-ID: | 84b7c6460609031711u2999a4dfsa49b4ee26d755a0e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 9/4/06, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> Frank Church wrote:
> > error: cannot cast tupe double precision to timestamp without time
> > zone
> >
> > What is the right syntax?
>
> It's not clear what the meaning of a double precision as a timestamp
> would be. How about you make that explicit:
>
> "timestamp" * interval '1 second' + timestamp '1900-01-01 00:00:00'
>
I tried the query in this form:
select *, "timestamp" * interval '1 second' + timestamp '1900-01-01
00:00:00' from ccmanager_log
This is the error message
ERROR: operator does not exist: interval + timestamp without time zone
HINT: No operator matches the given name and argument type(s). You
may need to add explicit type casts.
The version I am actually on is 7.4
- Hide quoted text -
> or whatever you had in mind.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Church | 2006-09-04 00:12:30 | Re: Syntax for converting double to a timestamp |
Previous Message | Michael Glaesemann | 2006-09-03 23:44:39 | Re: Syntax for converting double to a timestamp |