Skip site navigation (1) Skip section navigation (2)

Re: Re: to_date problems (Re: Favor for Postgres User at WSI)

From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kate Collins <klcollins(at)wsicorp(dot)com>, pgsql-bugs(at)postgresql(dot)org, John Rickman <john(dot)rickman(at)greatbridge(dot)com>
Subject: Re: Re: to_date problems (Re: Favor for Postgres User at WSI)
Date: 2000-11-12 18:54:59
Message-ID: 3A0EE783.70A6C3AF@catalyst.net.nz (view raw or flat)
Thread:
Lists: pgsql-bugs
Thomas Lockhart wrote:
> 
> Because of the common and documented cutoff date (1970 currently, 1950
> in some other apps) used to solve this problem.

Most database software I have seen uses some form of setting to control
the actual date used here, and that is the most long-term solution.

something like:
set CENTURY_WINDOW TO '1980';

Would be nicest.

Regards,
					Andrew.
-- 
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-11-13 07:10:15
Subject: Security problem in psql frontends
Previous:From: Thomas LockhartDate: 2000-11-12 16:10:14
Subject: Re: Re: to_date problems (Re: Favor for Postgres User at WSI)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group