this works for me: timestamp(your_variable)
Alla
stevenm@ot.com.au (Steve Micallef) wrote in message news:<20010613103614.W37166-100000@toaster.syd.ot>...
> Hi,
>
> I store Unix time stamps (seconds since Jan 1 1970) in my database. I was
> hoping there was an SQL/PostgreSQL function for converting a unix time
> stamp into a readable date/time string?
>
> I've searched the documentation, and there only seems to be functions
> which deal with time stamps (XXXX-XX-XX XX:XX:XX).
>
> Thanks in advance,
>
> Steve Micallef
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)