Re: Convert interval to hours

2018-09-14 Thread Peter Kleiner
On Fri, Sep 14, 2018 at 11:51 AM David Gauthier wrote: > > Hi: > > In perl/DBI, I have code that's getting me an "age" which returns something > like... "-17 days -08:29:35". How can I convert that to a number of hours > (as a float I would presume) ? > > Thanks > > > > I've done this as selec

Re: Convert interval to hours

2018-09-14 Thread Peter Kleiner
On Fri, Sep 14, 2018 at 2:42 PM Steven Lembark wrote: > > On Fri, 14 Sep 2018 12:21:14 -0400 > David Gauthier wrote: > > > I'm using postgres v9.5.2 on RH6. > > PG can convert the times for you. > For times (not timestamps) you are always better off dealing with > either time or integer seconds.

Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20

2024-12-01 Thread Peter Kleiner
Seems too easy but have you tried psql -p 6432 -h localhost words_de ? On Sun, Dec 1, 2024 at 3:59 PM Alexander Farber wrote: > My problem is related to > https://github.com/docker-library/postgres/pull/440/files > > But I am yet not sure how to enable listening at localhost again >