Re: To_char statement problems - Mailing list pgsql-general

From Jim Wilson
Subject Re: To_char statement problems
Date
Msg-id twig.1081451224.77837@kelcomaine.com
Whole thread Raw
In response to To_char statement problems  (Clark Endrizzi <endrizzi@xmission.com>)
Responses Re: To_char statement problems
List pgsql-general
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


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Can we have time based triggers in Postgresql??
Next
From: Ron St-Pierre
Date:
Subject: Re: To_char statement problems