Sender: lockhart@hub.org
Message-ID: <3847F1FB.6AB04307@alumni.caltech.edu>
Date: Fri, 03 Dec 1999 16:38:19 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
MIME-Version: 1.0
To: Oscar Serrano <oserra@fondos.net>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
References: <199911280627.BAA13538@lee.k12.nc.us>
	<002801bf3a6b$68d27d40$701d04d5@pep>
	<19991130112714.A375@fam-meskes.de>
	<00c501bf3d9c$e1875b00$c85204d5@pep>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> I've seen that declaring don't-remember-what variable, the dates were
> returned in the west-european format (dd/mm/aa).
> Won't be a similar variable to the number format?

No, unfortunately they are not related. The date/time routines can't
simply use localization, because:

1) the allowed time range for several date/time types exceeds the
Unix-supported range.

2) localization for input supports only one style at a time in
general.

We've got explicit code to allow several (4) different date/time
styles, which is what gives you the western European format.

By contrast, we use the system-supplied numeric i/o routines, so don't
have full control over formatting options. That may be a good thing,
since I would assume the system does a more efficient job than we
would.

                   - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California