From: | Memphisto <szoli(at)valerie(dot)inf(dot)elte(dot)hu> |
---|---|
To: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] datetime problems |
Date: | 1998-10-21 15:14:40 |
Message-ID: | Pine.GSO.3.96.981021170847.29288A-100000@valerie.inf.elte.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 21 Oct 1998, Herouth Maoz wrote:
> At 15:45 +0200 on 21/10/98, Memphisto wrote:
>
>
> > I'm terrible sorry, I meant to type login_start and no login_time which is
> > and intervallum. Thanks again for your help.
>
> By the way, I was thinking, and my WHERE clause may not catch datetimes
> which are on Aug 31, 1998, in the middle of the day. Better use:
>
> WHERE the_date >= '1998-08-01' AND the_date < '1998-09-01';
>
Thanks.
Another problem. I issued the following query:
select * from annex_log where login_start
between
(select date_trunc('month','now'::datetime)) and
(select date_trunc('month','now'::datetime)) +
timespan('1 month'::reltime);
but postgresql said there's a parse error near select
while the following query did work
select * from annex_log where login_start >=
(select date_trunc('month','now'::datetime)) and login_start <
(select date_trunc('month','now'::datetime) +
timespan('1 month'::reltime));
Why?
--------------------------------------------------------------------------------
Sebestyén Zoltán AKA Memphisto It all seems so stupid,
it makes me want to give up.
szoli(at)neumann(dot)cs(dot)elte(dot)hu But why should I give up,
when it all seems so stupid?
MAKE INSTALL NOT WAR And please avoid Necrosoft Widows
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1998-10-21 15:33:55 | Re: [GENERAL] datetime problems |
Previous Message | Herouth Maoz | 1998-10-21 14:01:11 | Re: [GENERAL] datetime problems |