Validity check in to_date?
От | Alexander M. Pravking |
---|---|
Тема | Validity check in to_date? |
Дата | |
Msg-id | 20031127141125.GC87728@dyatel.antar.bryansk.ru обсуждение исходный текст |
Ответы |
Re: Validity check in to_date?
Re: Validity check in to_date? |
Список | pgsql-sql |
I just discovered that to_date() function does not check if supplied date is correct, giving surprising (at least for me) results: fduch=# SELECT to_date('31.11.2003', 'DD.MM.YYYY'); to_date ------------2003-12-01 or even fduch=# SELECT to_date('123.45.2003', 'DD.MM.YYYY'); to_date ------------2007-01-03 to_timestamp() seems to work the same way. It's probably useful sometimes, but not in my case... Is it how it supposed to work? If so, how can I do such a validity check? If not, has something changed in 7.4? In any case, I have to find a workaround now and will appreciate any help. fduch=# SELECT version(); version ---------------------------------------------------------------------PostgreSQL 7.3.4 on i386-portbld-freebsd4.8, compiledby GCC 2.95.4 -- Fduch M. Pravking
В списке pgsql-sql по дате отправления: