Date posted: February 5, 2011 | Posted by: Andrew Hill

Linux

Under Linux, type command in postgres database:

set lc_monetary to 'ar_BH.utf8';

ar_BH represents Arabic (Bahrain) locale, the above command change the locale monetary setting on-the-fly in postgresql database, then let do a test:

select 34.888::text::money;

You will get 34.888 …

Date posted: January 7, 2011 | Posted by: Andrew Hill

Living in a country, where our currency symbol is the $ x.00, I wasn’t aware of the vast differences between countries and how they deal with currency.  France uses , instead of . for decimals. Germany uses a space instead…

Date posted: August 25, 2010 | Posted by: Andrew Hill

In west Australia, like Perth, when you are using postgresql database, you may need to change the time zone abbreviations to Australia:

change it for a session

postgres=# set timezone_abbreviations to ‘Australia’;

change it for database

postgres=# alter database DATABASENAME…