difficulty formating interval datatypes in 7.4

From: Chris Matheson <chris(at)centralfrontenac(dot)com>
To: postgresql-general(at)postgresql(dot)org
Subject: difficulty formating interval datatypes in 7.4
Date: 2005-10-19 20:22:29
Message-ID: 4356AB05.1010709@centralfrontenac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

I am working to format an interval in using the to_char() SQL function
on postgresql 7.4.8. I've had nothing but disapointment so far.
My confusion occurs when I'm trying to format using days where the days
output would be more than 99. For example:
I would like to do something like
SELECT to_char('01-JAN-2001'::timestamp - '01-JAN-2000'::timestamp,
'ddd "days" hh24 "hours"');
To get this
'365 days 00 hours'
Currently I get this
'335 days 00 hours'
I know that 'ddd' doesn't exist in the sense I'm thinking, but, it seems
that either I've missed something or that to_char function wasn't
designed with intervals in mind. The 7.4 manual lists the following
"Warning: |to_char|(interval, text) is deprecated and should not be used
in newly-written code. It will be removed in the next version."
But doesn't say what the alternative is. Thanks for your help.

Chris M.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2005-10-19 20:32:13 Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys
Previous Message Dann Corbit 2005-10-19 20:16:23 Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase)