Bruno Wolff III wrote:
On Thu, Jun 19, 2003 at 02:43:12 -0500, Ron Johnson <[EMAIL PROTECTED]> wrote:
OTOH, Andrew Snow's method (alway use ANSI standard YYYY-MM-DD) is guaranteed to work. Have your app convert to that format before inserting, and then PostgreSQL is guaranteed to puke if there's a problem.
No it isn't. In 7.4: area=> select '2003-20-02'::date; date ------------ 2003-02-20 (1 row)
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html