Re: what's wrong with my date comparison? - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: what's wrong with my date comparison?
Date
Msg-id 3DA72981-52FC-4044-A24A-D513FF3947DE@seespotcode.net
Whole thread Raw
In response to what's wrong with my date comparison?  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-sql
On Oct 16, 2007, at 12:57 , Tena Sakai wrote:

>  select name, value, datecreated
>    from mytable
>   where datecreated > 2007-10-02;
where datecreated > '2007-10-02'

2007-10-02 = 1995.

# select current_date < 2007-10-31 as arithmetic_comparison,  
current_date < '2007-10-31' as date_comparison;
arithmetic_comparison | date_comparison
-----------------------+-----------------
f                     | t
(1 row)

Michael Glaesemann
grzm seespotcode net




pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: what's wrong with my date comparison?
Next
From: Tom Lane
Date:
Subject: Re: what's wrong with my date comparison?