Re: to_char and i18n - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: to_char and i18n
Date
Msg-id 200603030239.k232dxb28306@candle.pha.pa.us
Whole thread Raw
In response to Re: to_char and i18n  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: to_char and i18n
List pgsql-hackers
Added to TODO:
* Add missing parameter handling in to_char()     http://archives.postgresql.org/pgsql-hackers/2005-12/msg00948.php

I added a URL in TODO because it is a single message of detail I need to
reference.

---------------------------------------------------------------------------

Gavin Sherry wrote:
> On Wed, 21 Dec 2005, Tom Lane wrote:
> 
> > Manuel Sugawara <masm@fciencias.unam.mx> writes:
> > > (Some time ago I proposed an--incomplete--patch and it was rejectd by
> > > Karel arguing that to_char functions should behave *exactly* the same
> > > way that they do in Oracle.)
> >
> > That is the accepted plan for to_char ... of course, if Oracle changes
> > to_char every so often, it'll get more interesting to decide what to do.
> 
> There's some functionality in 10g which PostgreSQL does not have:
> 
> TZD - returns the short timezone string with daylight saving information,
> eg: PDT
> 
> TZM - timezone offset minutes part
> 
> TZH - timezone offset hours part
> 
> TZR -  timezone region (US/Pacific, for example)
> 
> RR/RRRR - accept 'rounded' years, eg 99-1-1 = 1999-1-1 (kind of pointless)
> 
> FF - specify how many digits to the right of the decimal place to display,
> when looking at factions of seconds. Eg: HH:MM:SS.FF3 would produce
> 15:56:22.123
> 
> X - the local radix character. Eg: HH:MM:SSXFF would produce 15:56:22.123
> 
> E - Era name (like, Japanese Imperial) (kind of pointless)
> EE - Full era name
> 
> DS - Locale formatted short date. For example, DD/MM/YYYY for the Brits,
> MM/DD/YYYY for the Yanks
> 
> DL - Locale formatted long date. Eg: fmDay, dd. Month yyyy in Germany
> 
> SCC - Like 'CC', but will carry a - (minus) for BC dates (I'm not sure if
> this implies that Oracle wants BC dates to be marked 'BC'. I don't have
> an Oracle system around at the moment to check though :-()
> 
> TS - Locale formatted short time.
> 
> YEAR - Year in words
> 
> SYEAR - Year in words, prefixed by minus sign for BC dates
> 
> SYYYY - YYYY, prefixed by minus sign for BC dates
> 
> Gavin
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 

--  Bruce Momjian   http://candle.pha.pa.us SRA OSS, Inc.   http://www.sraoss.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] to_char and i18n
Next
From: Christopher Browne
Date:
Subject: Re: PostgreSQL Anniversary Summit, Call for Contributions