| Lists: | pgsql-novice |
|---|
| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | <tdn(at)tdn(dot)co(dot)ke>, <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: date conversions |
| Date: | 2002-06-04 16:31:13 |
| Message-ID: | web-1498763@davinci.ethosmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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
| From: | <tdn(at)tdn(dot)co(dot)ke> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | date conversions |
| Date: | 2002-06-05 15:07:59 |
| Message-ID: | 03b301c20ca2$c7980820a55cac3@uunetc6y2xvsq6 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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