From: | Ron St-Pierre <rstpierre(at)syscor(dot)com> |
---|---|
To: | Clark Endrizzi <endrizzi(at)xmission(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: To_char statement problems |
Date: | 2004-04-08 19:34:10 |
Message-ID: | 4075A932.7020709@syscor.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | John Hagstrand | 2004-04-08 19:34:53 | Re: ERROR: invalid memory alloc request size 0 |
Previous Message | Brian C. Doyle | 2004-04-08 19:31:44 | Date Comparison Help |