Steve Micallef <stevenm(at)ot(dot)com(dot)au> wrote:
> 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?
You can use something like
to_char(timestamp(foo), 'DD-MM-YYYY HH24:MI:SS')
HTH,
Ray
--
USDoJ/Judge Jackson: "Microsoft has performed an illegal operation and will
be shut down."
James Turinsky in alt.sysadmin.recovery