Postgres Pro
Downloads
Home   >   mailing lists

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

From Wei
Subject How do I convert an integet to a timestamp?
Date
Msg-id 1126548068.702382.67260@z14g2000cwz.googlegroups.com
Whole thread Raw
Responses Re: How do I convert an integet to a timestamp?
Re: How do I convert an integet to a timestamp?
List pgsql-sql
Tree view 
Hi.

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 is the proper way to do the conversion?

Thanks

Wei

pgsql-sql by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Need help with `unique parents` constraint
Next
From: Ron Mayer
Date:
Subject: Re: Indexing an array?