jump to navigation

format prices in Oracle February 1, 2007

Posted by maxmil in : Oracle , trackback

I’ve just stumbled on a useful SQL syntax for formating prices in Oracle whilst taking internationalization into account.TO_CHAR(field, '999G990D00L') AS importeThis would give ###,###.##$ in the US and ###.###,###€ in Spain

Comments»

no comments yet - be the first?