Unexpected parse behaviour for date to timestamp conversion

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема Unexpected parse behaviour for date to timestamp conversion
Дата
Msg-id 3E68C9C6.2070706@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: Unexpected parse behaviour for date to timestamp  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I have this field:

submit   | timestamp(0) without time zone


The following two SQL queries return different values depending on
wether the date is quoted or not ...

I am assuming it is because the date is being parsed differently.

# select submit from invoices where submit <= 2003-03-09;
  submit
----------
(0 rows)

# select submit from invoices where submit <= '2003-03-09';
  submit
---------------------
  2003-03-08 00:24:25
(1 row)


Why is the '2003-03-09' parsed/unserstood differently than 2003-03-09?

Thanks,

Jc


В списке pgsql-general по дате отправления:

Предыдущее
От: valerian
Дата:
Сообщение: Re: index on lower(column) is very slow
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PgHosts