Thread: TO_CHAR and Separate thousand

Hi People,

    Someone can say if its possible use TO_CHAR to define point "." like separate thousands ?

    Thank you so much for any help.


Regards,


Paulo Cuellas

Paulo Cuellas wrote:
> Hi People,
>
>     Someone can say if its possible use TO_CHAR to define point "." like
> separate thousands ?
>
>     Thank you so much for any help.

Sure, our documentation has a few examples:

    to_char(148.5, '999D999')    ' 148,500'
    to_char(3148.5, '9G999D999')    ' 3 148,500'

Here, the locale has the thousands separator as space.  I am assuming
your locale is set up with the thousands marker as period.  Are you
asking for the period as the thousands separator even though your locale
isn't set that way?

PostgreSQL 8.1 RC1 also has psql '\pset numericlocale' which outputs all
numerics in locale-specific format, but again that is going to be all
driven by locale.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073