Re: what's wrong with my date comparison?

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: what's wrong with my date comparison?
Дата
Msg-id 3DA72981-52FC-4044-A24A-D513FF3947DE@seespotcode.net
обсуждение исходный текст
Ответ на what's wrong with my date comparison?  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: what's wrong with my date comparison?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: what's wrong with my date comparison?