multiply by 100 and drop the decimal point

to_char(ASU_total_in_year * 100, 999999999999)

butler daniel wrote:

>Hi,
>
>I have some sql
>
>to_char(ASU_total_in_year),999999999.99)
>
>This Displays data in pounds and pence with a decimal point, how can I get
>it TO display the amount in just pennies ? i.e.. £10.50 should become 1050
>pennies
>
>Any Ideas ?
>
>Cheers
>
>DAN
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>

Oracle LazyDBA home page