Re: Internationalized dates (was Internationalized error messages) - Mailing list pgsql-hackers

From Karel Zak
Subject Re: Internationalized dates (was Internationalized error messages)
Date
Msg-id 20010312111145.B2268@ara.zf.jcu.cz
Whole thread Raw
In response to Internationalized dates (was Internationalized error messages)  (Kaare Rasmussen <kar@webline.dk>)
Responses Re: Internationalized dates (was Internationalized error messages)  (ncm@zembu.com (Nathan Myers))
List pgsql-hackers
On Fri, Mar 09, 2001 at 10:58:02PM +0100, Kaare Rasmussen wrote:
> Now you're talking about i18n, maybe someone could think about input and
> output of dates in local language.
> 
> As fas as I can tell, PostgreSQL will only use English for dates, eg January,
> February and weekdays, Monday, Tuesday etc. Not the local name.
May be add special mask to to_char() and use locales for this, but I not
sure. It isn't easy -- arbitrary size of strings, to_char's cache problems
-- more and more difficult is parsing input with locales usage. 
The other thing is speed...
A solution is use number based dates without names :-(        Karel

PS. what other SQL engines, support it?

-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz


pgsql-hackers by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: SIGTERM/FATAL error
Next
From: Karel Zak
Date:
Subject: Re: Internationalized error messages