Thread: date conversions

date conversions

From
Date:
Hi

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

Rgds
TDN



Re: date conversions

From
"Josh Berkus"
Date:
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