Formatted numeric output: Difference between revisions
Content added Content deleted
(Add zero fill) |
|||
Line 25: | Line 25: | ||
declare @n int |
declare @n int |
||
select @n=123 |
select @n=123 |
||
select substring(convert(char(5), 10000+@n),2,4) as |
select substring(convert(char(5), 10000+@n),2,4) as FourDigits |
||
⚫ | |||
set @n=5 |
|||
print "TwoDigits: " + substring(convert(char(3), 100+@n),2,2) |
|||
⚫ |
Revision as of 01:20, 11 February 2007
![Task](http://static.miraheze.org/rosettacodewiki/thumb/b/ba/Rcode-button-task-crushed.png/64px-Rcode-button-task-crushed.png)
You are encouraged to solve this task according to the task description, using any language you may know.
Express a number in decimal as a fixed-length string with leading zeros.
JavaScript
var n = 123 var str = ("00000"+m).slice(-5) alert(str) //or, put in browser URL: javascript:n=123;alert(("00000"+n).slice(-5))
Python
#tested in Python 2.4.1 n = 123 str = "%05d" % n #5 places wide, leading zeros print n, str #output: 123 00123
SQL
--Tested MS SQL 2005 declare @n int select @n=123 select substring(convert(char(5), 10000+@n),2,4) as FourDigits
set @n=5 print "TwoDigits: " + substring(convert(char(3), 100+@n),2,2) --Output: 05