Re: [GENERAL] formatting a date

2001-05-10 Thread Tom Lane
Zak McGregor <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TI

Re: [GENERAL] formatting a date

2001-05-10 Thread Zak McGregor
On Thu, 10 May 2001 15:30:01 -0400 Fran Fabrizio <[EMAIL PROTECTED]> wrote: > > I'm looking all over the place in the Pg docs and Momjian book and > having no luck finding any functions that would turn a timestamp such as > 2001-05-08 23:59:59-04 into May 8, 2001. (i.e. do what date_format() >

[GENERAL] formatting a date

2001-05-10 Thread Fran Fabrizio
I'm looking all over the place in the Pg docs and Momjian book and having no luck finding any functions that would turn a timestamp such as 2001-05-08 23:59:59-04 into May 8, 2001. (i.e. do what date_format() was doing for me in MySQL.) Is there equivalent functionality in Pg? Thanks, Fran