By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,603 Members | 1,062 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,603 IT Pros & Developers. It's quick & easy.

To_char statement problems

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
On Thu, Apr 08, 2004 at 19:07:04 -0000,
Jim Wilson <ji**@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.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.