Обсуждение: 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!

-- 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.