Re: formatting a date

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zak McGregor <zak(at)mighty(dot)co(dot)za>
Cc: Fran Fabrizio <ffabrizio(at)Exchange(dot)WebMD(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: formatting a date
Date: 2001-05-10 21:25:04
Message-ID: 25070.989529904@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zak McGregor <zak(at)mighty(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Coers 2001-05-10 21:30:36 Re: COPY locking
Previous Message Tom Lane 2001-05-10 21:22:07 Re: Re: Query not using index