Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I convert an integet to a timestamp? - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: How do I convert an integet to a timestamp?
Date
Msg-id 20050913045307.GA98267@winnie.fuhr.org
Whole thread Raw
In response to How do I convert an integet to a timestamp?  ("Wei" <wengwei@gmail.com>)
List pgsql-sql
Tree view 
On Mon, Sep 12, 2005 at 11:01:08AM -0700, Wei wrote:
> I followed the doc and tried "select CAST(1126547334 AS timestamp)" and
> I only got an error response that says: ERROR:  cannot cast type
> integer to timestamp without time zone.

What documentation suggested casting an integer to a timestamp?

> What is the proper way to do the conversion?

See "Date/Time Functions and Operators" -- it has an example of what
you're trying to do:

http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html

-- 
Michael Fuhr

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: user defined type, plpgsql function and NULL
Next
From: "Eugene E."
Date:
Subject: Re: How do I convert an integet to a timestamp?