Re: How do I convert an integet to a timestamp?

Wei wrote:
> 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?

select 123456789::abstime::timestamp;