Padding Negative numbers in SQL and Etext Templates

 I had a requirement to display a negative number left padded with 0's in etext template. This is how you do it.

FORMAT_NUMBER(-25,'00000000') will give -00002500

In SQL this can be achieved using to_char('-25','000000000')