C#基础 字符串格式化

一、C# 语言
方法：
String.Format(format, string)  或者
变量.toString(format);

1.数字格式化
常用数字格式符号使用说明

字符	说 明	示    例	输  出
C	货币	string.Format("{0:C3}", 2)	＄2.000
D	十进制	string.Format("{0:D3}", 2)	002
E	科学计数法	1.20E+001	1.20E+001
F	浮点数默认两位小数	string.Format("{0:F}", 2)	2.00
G	常规	string.Format("{0:G}", 2)	2
N	用分号隔开的数字	string.Format("{0:N}", 250000)	250,000.00
R	float数据四舍五入	string.Format("{0:R}", 1.42)	1.42
X	十六进制	string.Format("{0:X000}", 12)	C
		string.Format("{0:000.000}", 12.2)	012.200

其他符号使用说明

Specifier	Type	Example	Output (Passed Double 1500.42)	Note
0	Zero placeholder	{0:00.0000}	1500.4200	Pads with zeroes.
#	Digit placeholder	{0:(#).##}	(1500).42
.	Decimal point	{0:0.0}	1500.4
,	Thousand separator	{0:0,0}	1,500	Must be between two zeroes.
,.	Number scaling	{0:0,.}	2	Comma adjacent to Period scales by 1000.
%	Percent	{0:0%}	150042%	Multiplies by 100, adds % sign.
e	Exponent placeholder	{0:00e+0}	15e+2	Many exponent formats available.
;	Group separator	see below

2.常用日期格式化方式

Specifier	Type	Example (Passed System.DateTime.Now)
d	Short date	10/12/2002
D	Long date	December 10, 2002
t	Short time	10:11 PM
T	Long time	10:11:29 PM
f	Full date & time	December 10, 2002 10:11 PM
F	Full date & time (long)	December 10, 2002 10:11:29 PM
g	Default date & time	10/12/2002 10:11 PM
G	Default date & time (long)	10/12/2002 10:11:29 PM
M	Month day pattern	December 10
r	RFC1123 date string	Tue, 10 Dec 2002 22:11:29 GMT
s	Sortable date string	2002-12-10T22:11:29
u	Universal sortable, local time	2002-12-10 22:13:50Z
U	Universal sortable, GMT	December 11, 2002 3:13:50 AM
Y	Year month pattern	December, 2002

 

Specifier	Type	Example	Example Output
dd	Day	{0:dd}	10
ddd	Day name	{0:ddd}	Tue
dddd	Full day name	{0:dddd}	Tuesday
f, ff, ...	Second fractions	{0:fff}	932
gg, ...	Era	{0:gg}	A.D.
hh	2 digit hour	{0:hh}	10
HH	2 digit hour, 24hr format	{0:HH}	22
mm	Minute 00-59	{0:mm}	38
MM	Month 01-12	{0:MM}	12
MMM	Month abbreviation	{0:MMM}	Dec
MMMM	Full month name	{0:MMMM}	December
ss	Seconds 00-59	{0:ss}	46
tt	AM or PM	{0:tt}	PM
yy	Year, 2 digits	{0:yy}	02
yyyy	Year	{0:yyyy}	2002
zz	Timezone offset, 2 digits	{0:zz}	-05
zzz	Full timezone offset	{0:zzz}	-05:00
:	Separator	{0:hh:mm:ss}	10:43:20
/	Separator	{0:dd/MM/yyyy}	10/12/2002

Some Useful Examples

String.Format("{0:＄#,##0.00;(＄#,##0.00);Zero}", value);
This will output "＄1,240.00" if passed 1243.50. It will output the same format but in parentheses
if the number is negative, and will output the string "Zero" if the number is zero.

String.Format("{0:(###) ###-####}", 18005551212);This will output "(800) 555-1212".

二、JavaScript

三、SQL/Oracel

转载于:https://www.cnblogs.com/sundongxiang/archive/2009/09/09/1563366.html