Formatted numeric output: Difference between revisions

From Rosetta Code
Content added Content deleted
Line 26: Line 26:
select @n=123
select @n=123
select substring(convert(char(5), 10000+@n),2,4) as FourDigits
select substring(convert(char(5), 10000+@n),2,4) as FourDigits

set @n=5
set @n=5
print "TwoDigits: " + substring(convert(char(3), 100+@n),2,2)
print "TwoDigits: " + substring(convert(char(3), 100+@n),2,2)

Revision as of 01:20, 11 February 2007

Task
Formatted numeric output
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