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