Received: from trillium.nmsu.edu (trillium.NMSU.Edu [128.123.5.15]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA11932 for ; Tue, 25 Aug 1998 13:20:30 -0400 (EDT) Received: (from brook@localhost) by trillium.nmsu.edu (8.8.8/8.8.8) id LAA05553; Tue, 25 Aug 1998 11:20:18 -0600 (MDT) Date: Tue, 25 Aug 1998 11:20:18 -0600 (MDT) Message-Id: <199808251720.LAA05553@trillium.nmsu.edu> From: Brook Milligan To: ericm@palaver.net CC: pgsql-sql@postgreSQL.org In-reply-to: (message from Eric McKeown on Mon, 24 Aug 1998 18:33:53 -0500 (EST)) Subject: Re: [SQL] parts of date_part() References: played with some other things, like 'month' and 'year'. However, I was wondering if there was a way to obtain the name of the day (Tuesday, Wednesday, etc.) using this function, among other things. I tried Try select date_part ('dow', field_name) from table ; This gives numbers 0-6 => Sunday-Saturday (I think). I suppose that could be joined with another table with names. Is there a more direct way to get the names? Cheers, Brook