Postgres Pro
Downloads
Home   >   mailing lists

Re: Why this query does not work? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Why this query does not work?
Date
Msg-id 17123.1052776423@sss.pgh.pa.us
Whole thread Raw
In response to Why this query does not work?  ("Katka a Daniel Dunajsky" <daniel_katka@hotmail.com>)
List pgsql-sql
Tree view 
"Katka a Daniel Dunajsky" <daniel_katka@hotmail.com> writes:
> Why this does not gives correct result?

You've missed the trailing blanks in TO_CHAR's result.

Probably you should be using FMMonth not Month as the format specifier.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Katka a Daniel Dunajsky"
Date:
Subject: Why this query does not work?
Next
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Why this query does not work?