Re: A creepy story about dates. How to prevent it?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A creepy story about dates. How to prevent it?
Дата
Msg-id 8456.1056031822@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: A creepy story about dates. How to prevent it?  ("Peter Haworth" <pmh@edison.ioppublishing.com>)
Ответы Re: A creepy story about dates. How to prevent it?  (nolan@celery.tssi.com)
Список pgsql-general
"Peter Haworth" <pmh@edison.ioppublishing.com> writes:
> On Wed, 18 Jun 2003 15:09:44 -0600 (MDT), scott.marlowe wrote:
>> Why not accept a date of 04/44/2003 and just wrap it into May?

> Unbelievably, to_date() already does that in 7.3.3:

It's only "unbelievable" if Oracle doesn't do the same thing.  to_date
and friends are Oracle compatibility functions and are intended to
slavishly imitate what Oracle does, warts and all (and there are
certainly plenty of warts there...)

Anyone care to run some tests to see how lax Oracle's to_date is?

            regards, tom lane

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Incremental backups, and backup history
Следующее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: attisdropped, * expansion and tg_trigtuple