From: Keith Worthington <KeithW@NarrowPathInc.com>
To: pgsql-sql@postgresql.org
Cc: Michael Glaesemann <grzm@myrealbox.com>
Subject: Re: dow question
Date: Wed, 07 Dec 2005 22:33:06 -0500
Message-ID: <4397A972.8060007@NarrowPathInc.com> (raw)
In-Reply-To: <E4B9C5CF-8776-4335-B819-D32E64A15DDC@myrealbox.com>
References: <43979459.9020500@NarrowPathInc.com>
<E4B9C5CF-8776-4335-B819-D32E64A15DDC@myrealbox.com>
Michael Glaesemann wrote:
>
> On Dec 8, 2005, at 11:03 , Keith Worthington wrote:
>
>> Is there a better way to do this? The CASE seems inefficient and
>> wordy but perhaps not.
>>
>> I was hoping for
>>
>> day_name(tbl_detail.ship_by_date) || tbl_detail.ship_by_date::text AS
>> sort_by_string
>>
>> but AFAIK day_name(date) or something like it is merely my fantasy. ;-)
>
>
> Will to_char() do what you want? Something like
>
> test=# select to_char(current_date, 'Day YYYY-MM-DD');
> to_char
> ----------------------
> Thursday 2005-12-08
> (1 row)
>
> http://www.postgresql.org/docs/current/interactive/functions-
> formatting.html
>
> Michael Glaesemann
> grzm myrealbox com
Michael,
That will do nicely. I didn't realize until now after your tip and
reading the to_char documentation how much I could do with to_char.
to_char(tbl_detail.ship_by_date, 'FMDay, YYYY/MM/DD') AS ship_by_string,
is exactly what the doctor ordered. Thanks for the tip.
--
Kind Regards,
Keith
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: KeithW@NarrowPathInc.com, grzm@myrealbox.com
Subject: Re: dow question
In-Reply-To: <4397A972.8060007@NarrowPathInc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox