Re: [SQL] Date comparisons

From: Haris Susanto <hariss(at)dnet(dot)net(dot)id>
To: pgsql-sql-digest <pgsql-sql(at)hub(dot)org>
Subject: Re: [SQL] Date comparisons
Date: 1999-10-28 09:46:02
Message-ID: 10698.991028@dnet.net.id
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

psd> hello ,try this :
psd> select * from a where a.cdate < '10-20-1999' ;

psd> regards,
psd> omid omoomi

-----
Usually I use this :
select * from a where date_trunc('day',cdate) < '10-20-1999';

Best regards,
Haris mailto:hariss(at)dnet(dot)net(dot)id

Browse pgsql-sql by date

  From Date Subject
Next Message Imtiaz. S. M 1999-10-28 10:47:03 SQL Problem
Previous Message Rich Ryan 1999-10-28 06:34:16 Setting default row value after select into table