Re: Unix time stamp function?

this works for me: timestamp(your_variable)

Alla

stevenm(at)ot(dot)com(dot)au (Steve Micallef) wrote in message news:<20010613103614(dot)W37166-100000(at)toaster(dot)syd(dot)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(at)postgresql(dot)org)