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