Re: A creepy story about dates. How to prevent it?

From: Tony Grant <tony(at)tgds(dot)net>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: A creepy story about dates. How to prevent it?
Date: 2003-06-24 16:52:43
Message-ID: 1056473563.2449.66.camel@vaio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2003-06-24 at 18:01, Lincoln Yeoh wrote:

>
> What if a European DB backed website is hosted on a US server with English,
> French and German data?

Dates are no big deal. The front end can translate PostgreSQL format
dates to/from whatever format you want.

My big challenge (I am in the above case - UK server [rackspace] and
French data) is the decimal separator. I can't figure how to get a ","
as my decimal seperator. If I try modifying postgresql.conf the
postmaster refuses to start. I _don't_ want to write a fance procedure
into each and every JSP to work around this. And my client refuses to
use the "."...

Cheers

Tony Grant
--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message PeterKorman 2003-06-24 16:56:54 Re: Looking for PERL documentation (fwd)
Previous Message Reuben D. Budiardja 2003-06-24 16:40:46 Re: [GENERAL] Documentation quality WAS: interesting