Thread: To_char statement problems
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!
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 |
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
Clark Endrizzi wrote: > 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 > You're telling it to give you month/day/year hour:month am[pm] Use MI for minutes instead of MM. Ron
On Thu, Apr 08, 2004 at 19:07:04 -0000, Jim Wilson <jimw@kelcomaine.com> wrote: > > You are telling it HH:MM where MM is the Month.... so it is doing exactly > what you asked for. And you want to use MI to get minutes.