Re: this date format thing.

On Wed, 2 Apr 2003 13:23:45 -0700 (MST), scott.marlowe wrote:
> While situations where 04-02 would get put in when the user meant 02-04,
> at least enough of the 02-13 cases would throw an error that the user
> would know they had been doing something wrong along the way and would
> hopefully go back and look at their data.

You wish.

jnlstats=> select version();
                           version
-------------------------------------------------------------
 PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

jnlstats=> set datestyle='ISO';
SET
jnlstats=> select '2001-12-31'::date;
    date
------------
 2001-12-31
(1 row)

jnlstats=> select '2001-31-12'::date;
    date
------------
 2001-12-31
(1 row)

jnlstats=> select to_date('2001-31-12','yyyy-mm-dd');
  to_date
------------
 2003-07-14
(1 row)


--
    Peter Haworth    pmh@edison.ioppublishing.com
"True, in chess you never get to grab your opponent, roll him around
 your hip and slam him (or her) to the floor but you get the idea"
        -- Simon Wistow