Received: from mail.mediaparks.lv (home.mediaparks.lv [195.2.123.220]) by hub.org (8.10.1/8.10.1) with ESMTP id e6A9p5W70920 for ; Mon, 10 Jul 2000 05:51:06 -0400 (EDT) Received: from sandis ([195.2.123.209]) by mail.mediaparks.lv (8.9.3/8.9.3) with SMTP id LAA26178 for ; Mon, 10 Jul 2000 11:48:54 +0300 Message-ID: <00c301bfea4c$265ff460$d17b02c3@mediaparks.lv> From: "sandis" To: References: <005a01bfe83e$4fc52600$d17b02c3@mediaparks.lv> <39663B6D.57B67664@ipinc.com> Subject: Re: date comparision ??? Date: Mon, 10 Jul 2000 11:52:16 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200007/130 Thanks for your input. Unfortunately, it doesn't helped.. Here is the samples. This query works fine: SELECT datums_ FROM jaunumi WHERE flag = 'a' AND date_part('year',datetime '2000-06-02 06:11:01-07') = '2000' LIMIT 1; datums_ ---------------------- 2000-07-06 18:51:27+03 (1 row) But this fails, obviously because the function doesnt know the value of datums_: SELECT datums_ FROM jaunumi WHERE flag = 'a' AND date_part('year',datetime 'datums_') = '2000' LIMIT 1; ERROR: Bad datetime external representation 'datums_' datums_ is a timestamp field. How do i get it's value to use in date_part() function?? date_part('year',datums_) and date_part('year',datetime datums_) doesnt work also! ----- Original Message ----- From: Jie Liang To: sandis Sent: Friday, July 07, 2000 11:19 PM Subject: Re: [SQL] date comparision Hi, it works for me: urldb=# \d deleted Table "deleted" Attribute | Type | Modifier -------------+-------------+---------- url | text | allocatedto | varchar(30) | deleteddate | timestamp | id | integer | not null Index: deleted_pkey so , I 've a field deleteddate(type is timestamp) in table deleted. urldb=# select deleteddate from deleted limit 10 offset 230000; deleteddate ------------------------ 1999-12-17 15:24:19-08 1999-12-17 15:25:14-08 1999-12-17 15:25:29-08 1999-12-17 15:25:35-08 2000-01-19 18:00:51-08 1999-12-17 15:27:02-08 1999-12-17 15:27:59-08 2000-01-19 18:00:54-08 1999-12-17 15:28:16-08 1999-12-17 15:28:20-08 urldb=# select deleteddate from deleted where year(deleteddate)=2000 and rtrim(monthname(deleteddate),' ')='June' and rtrim(dayname(deleteddate),' ')='Friday' limit 10; deleteddate ------------------------ 2000-06-02 06:11:01-07 2000-06-02 06:16:08-07 2000-06-02 06:23:17-07 2000-06-02 06:23:17-07 2000-06-02 06:23:17-07 2000-06-02 06:45:30-07 2000-06-02 06:49:55-07 2000-06-02 07:08:27-07 2000-06-02 07:13:21-07 2000-06-02 07:13:21-07 (10 rows) Good luck!!! -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com