From: sandis <sandis@mediaparks.lv>
To: pgsql-sql@postgresql.org
Subject: Re: date comparision ???
Date: Mon, 10 Jul 2000 11:52:16 +0300
Message-ID: <00c301bfea4c$265ff460$d17b02c3@mediaparks.lv> (raw)
References: <005a01bfe83e$4fc52600$d17b02c3@mediaparks.lv>
<39663B6D.57B67664@ipinc.com>
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
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: sandis@mediaparks.lv
Subject: Re: date comparision ???
In-Reply-To: <00c301bfea4c$265ff460$d17b02c3@mediaparks.lv>
References: <005a01bfe83e$4fc52600$d17b02c3@mediaparks.lv> <39663B6D.57B67664@ipinc.com> <00c301bfea4c$265ff460$d17b02c3@mediaparks.lv>
* 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