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 with 3 decimal places money type. Tested in Postgresql 8.4.6. Windows However the above set… View Article

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 of a comma.  The decimal places in some currencies have 3 decimal places, or no… View Article

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 sessionpostgres=# set timezone_abbreviations to ‘Australia’;change it for databasepostgres=# alter database DATABASENAME set timezone_abbreviations to ‘Australia’;