Clark Endrizzi said:
> 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.
>
You are telling it HH:MM where MM is the Month.... so it is doing exactly
what you asked for.
Best,
Jim
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
