Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0I2PP089204 for ; Wed, 17 Jan 2001 21:25:25 -0500 (EST) (envelope-from tjk@tksoft.com) Received: from uno.tksoft.com (smtp3.tksoft.com [192.168.50.56] (may be forged)) by as.tksoft.com (8.8.8/8.8.8) with ESMTP id SAA13044; Wed, 17 Jan 2001 18:28:02 -0800 Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id RAA06019; Wed, 17 Jan 2001 17:40:23 -0800 From: "tjk@tksoft.com" Message-Id: <200101180140.RAA06019@uno.tksoft.com> Subject: Re: Select 'Sunday' in month ?? To: nizomi@dnet.net.id (Tubagus Nizomi) Date: Wed, 17 Jan 2001 17:40:23 -0800 (PST) Cc: pgsql-sql@postgresql.org In-Reply-To: <01011808283800.01195@nizomi> from "Tubagus Nizomi" at Jan 18, 2001 08:28:38 AM X-Mailer: ELM [version 2.5 PL2] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/201 X-Sequence-Number: 866 E.g. create table mytable (created datetime); insert into mytable values ('01-01-2001'); ... insert into mytable values ('01-31-2001'); select created from mytable where date_part('dow', created) = 7 and date_part('month', created) = 1; Troy > > i want to select date in january where day='Sunday' > > any idea ?? > > please help me > > Nizomi >