How do I convert an integet to a timestamp?

From: "Wei" <wengwei(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How do I convert an integet to a timestamp?
Date: 2005-09-12 18:01:08
Message-ID: 1126548068.702382.67260@z14g2000cwz.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Leif B. Kristensen 2005-09-12 18:02:34 Re: Need help with 'unique parents' constraint
Previous Message gherzig 2005-09-12 15:21:22 refer a column as a varible name?