From: | Kaare Rasmussen <kar(at)kakidata(dot)dk> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | to_number |
Date: | 2003-03-30 12:54:29 |
Message-ID: | 200303301454.30758.kar@kakidata.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
# SELECT * FROM pg_settings WHERE name LIKE 'lc_%';
name | setting
-------------+---------
lc_messages | unset
lc_monetary | C
lc_numeric | C
lc_time | C
(4 rows
SELECT price, to_number(price,'9999D9)') FROM orderline WHERE sku =
'01-0082-4';
price | to_number
-------+-----------
429,5 | 4295
429,5 | 4295
429,5 | 4295
429,5 | 4295
429,5 | 4295
429,5 | 4295
429,5 | 4295
429,5 | 4295
429,5 | 4295
429,5 | 4295
(10 rows)
How can to_number work with Danish locale?
--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 Åben 12.00-18.00 Email: kar(at)kakidata(dot)dk
2000 Frederiksberg Lørdag 12.00-16.00 Web: www.suse.dk
From | Date | Subject | |
---|---|---|---|
Next Message | Kaare Rasmussen | 2003-03-30 17:24:38 | Re: to_number |
Previous Message | Tomasz Myrta | 2003-03-30 06:56:26 | Re: to_number |