| From: | Clark Endrizzi <cendrizzi(at)naiutah(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | First Question: to_char statement problems |
| Date: | 2004-04-08 18:01:24 |
| Message-ID: | 1081447284.5067.220.camel@fedora.naiutah.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clark Endrizzi | 2004-04-08 18:07:09 | To_char statement problems |
| Previous Message | Mark Lubratt | 2004-04-08 17:59:38 | Orphaned trigger -- bug? |