To_char statement problems

From: Clark Endrizzi <endrizzi(at)xmission(dot)com>
To: Postgresql General List <pgsql-general(at)postgresql(dot)org>
Subject: To_char statement problems
Date: 2004-04-08 18:07:09
Message-ID: 1081447629.5067.225.camel@fedora.naiutah.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just sent this twice before with the wrong email address so it didn't
go through, that is why I am sending this so that it will get through.
I hope this isn't causing issues.

Hi guys. I certainly hope this is the correct place to email this. I'm
having an issue that I have really tried to solve but can't.

I'm using RHEL's postgresql 7.3.4 and everything works great except my
to_char() statements. The most common conversion string I use is
'MM/DD/YYYY HH:MM AM' which works except the minutes are never correct,
they always end with ":04". So if I submitted it at 10:23 AM it will
say 10:04 after conversion.

I know Redhat doesn't have the newest version but I can't believe that
they would have such a big problem. Is this just a problem in this
version? Is my syntax incorrect?

Thanks!
--
Clark Endrizzi
NAI Utah Commercial Real Estate
801-578-5522

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randall Skelton 2004-04-08 18:28:37 extract epoch and index scanning
Previous Message Clark Endrizzi 2004-04-08 18:01:24 First Question: to_char statement problems