Postgres Pro
Downloads
Home   >   mailing lists

Re: date conversions - Mailing list pgsql-novice

From Josh Berkus
Subject Re: date conversions
Date
Msg-id web-1498763@davinci.ethosmedia.com
Whole thread Raw
In response to date conversions  (<tdn@tdn.co.ke>)
List pgsql-novice
Tree view 
TDN,

> I have a table with unix timestams stored as integer, and would like
> to
> convert that to date, including the time component...
> any ideas

Please see:
http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/functions.html

-Josh Berkus

pgsql-novice by date:

Previous
From:
Date:
Subject: date conversions
Next
From: "Peter Alberer"
Date:
Subject: Using case in an update statement ?