Postgres Pro
Downloads
Home   >   mailing lists

Re: formatting a date - Mailing list pgsql-general

From Tom Lane
Subject Re: formatting a date
Date
Msg-id 25070.989529904@sss.pgh.pa.us
Whole thread Raw
In response to Re: formatting a date  (Zak McGregor <zak@mighty.co.za>)
Responses Re: formatting a date  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
Tree view 
Zak McGregor <zak@mighty.co.za> writes:
> It pads the output of the month to 9 places, btw.

You can suppress the padding with the right format-string incantation.
See the docs.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Query not using index
Next
From: "Richard Huxton"
Date:
Subject: Re: Re: Query not using index