Postgres Pro
Downloads
Home   >   mailing lists

First Question: to_char statement problems - Mailing list pgsql-general

From Clark Endrizzi
Subject First Question: to_char statement problems
Date
Msg-id 1081447284.5067.220.camel@fedora.naiutah.local
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Wes Palmer
Date:
Subject: Re: thread_test.c problems
Next
From: Alexander Cohen
Date:
Subject: pg_ctl problem