Home > mailing lists

formating interval question - Mailing list pgsql-general

From	mike
Subject	formating interval question
Date	September 24, 2004 15:07:35
Msg-id	1096023524.12742.5.camel@datacc Whole thread Raw
Responses	Re: formating interval question (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

I have an interval field which is used to calculate total hours.

At present it outputs as days hours minutes

Is there any way to output as total hours

I have tried to_char(field,'HH:MM')

but I get wierd results like -51 or -5

pgsql-general by date:

From: Daniel Martini
Date: 24 September 2004, 13:33:14
Subject: plpgsql-fct. fails on NULL in record variables

From: Manolatos Tilemahos
Date: 24 September 2004, 15:55:03
Subject: How to pass initdb LC_COLLATE & locale parameters when using wind ows? (with or without pginstaller)

formating interval question - Mailing list pgsql-general

Previous

Next