timestamp bogus parser?

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема timestamp bogus parser?
Дата
Msg-id alpine.DEB.2.22.394.2012231928011.1129962@pseudo
обсуждение исходный текст
Список pgsql-hackers
Hello,

I tried:

  psql> SELECT TIMESTAMP '2020-12-23Z19:28:45';

The result of which is:

  2020-12-23 00:00:00

This is disappointing. Ok, my fault, I should have written TIMESTAMPTZ, or 
use T instead of Z, or whatever.

Anyway, is there a rational for this behavior? I would have expected 
either the time to be taken into account or an error message, but 
certainly not half of my string being silently ignored. Skimming through 
the doc (Section 8.5.1.3) did not provide an answer.

Any clues? Is this a bug?

-- 
Fabien.



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Re: Cache relation sizes?
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: New Table Access Methods for Multi and Single Inserts