From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Oscar Serrano <oserra@fondos.net>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Date: Fri, 03 Dec 1999 16:38:19 +0000
Message-ID: <3847F1FB.6AB04307@alumni.caltech.edu> (raw)
References: <199911280627.BAA13538@lee.k12.nc.us>
<002801bf3a6b$68d27d40$701d04d5@pep>
<19991130112714.A375@fam-meskes.de>
<00c501bf3d9c$e1875b00$c85204d5@pep>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, oserra@fondos.net
Subject: Re: [INTERFACES] Spanish format on date and numbers
In-Reply-To: <3847F1FB.6AB04307@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox