把σも

DTW_FORMAT


AIX HP-UX Linux OS/2 OS/390 OS/400 PTX SUN Win NT
X X X X X X X X X

ヘ

︽砞﹚计Α

Α

@DTW_FORMAT(number, before, after, expp, expt, precision, result)

@DTW_FORMAT(number, before, after, expp, expt, result)

@DTW_FORMAT(number, before, after, expp, result)

@DTW_FORMAT(number, before, after, result)

@DTW_FORMAT(number, before, result)

@DTW_FORMAT(number, result)

@DTW_rFORMAT(number, before, after, expp, expt, precision)

@DTW_rFORMAT(number, before, after, expp, expt)

@DTW_rFORMAT(number, before, after, expp)

@DTW_rFORMAT(number, before, after)

@DTW_rFORMAT(number, before)

@DTW_rFORMAT(number)

把计

 64. DTW_FORMAT 把计
戈摸 把计 ㄏノ 弧
疊翴计 number IN 琘计跑计┪ゅ﹃
俱计 before IN タЧ俱计跑计┪ゅ﹃ 硂琌匡ノ把计 眤ゲ斗块﹃ ("") 局Τ肂把计
俱计 after IN タЧ俱计跑计┪ゅ﹃ 硂琌匡ノ把计 眤ゲ斗块﹃ ("") 砞﹚肂把计
俱计 expp IN タЧ俱计跑计┪ゅ﹃眤ゲ斗砞﹚﹃ ("") 砞﹚肂把计
俱计 expt IN タЧ俱计跑计┪ゅ﹃眤ゲ斗块﹃ ("") 砞﹚肂把计
俱计 precision IN ﹚挡狦ぇ弘絋ぇタ俱计 跑计┪ゅ﹃箇砞琌 9
疊翴计 result OUT ┮﹚ぇ俱计て㎝Αてぇ计 

滦絏

 65. DTW_FORMAT 滦絏
滦絏 弧
-1001 狝竟礚猭矪瞶 Net.Data 皌竚癘拘砰璶―
1001 块把计 NULL 
1002 块把计﹃Τじ挡Ю
1003 ㄧ计㊣肚患把计计ヘぃタ絋
1005 ㄧ计㊣肚患把计ゲ斗琌﹃跑计玱琌ぃ跑计摸
1006 ゅ﹃肚患倒ㄧ计㊣い把计 把计ゲ斗琌块把计
4000 把计礚俱计
4001 把计礚计

ノ猭猔種ㄆ兜

  1. 狦Τ﹚ number 把计玥挡狦盢穦ΑてΘ @DTW_rADD(number,"0") 磅︽挡狦
  2. beforeafter 把计盢弧Τぶじ 穦だ砆ノㄓ result 把计い俱计籔 计场狦眤菠硂ㄇ把计い兜┪ㄢ兜 玥ê场じ计籔┮惠妓
  3. 狦 before 把计ぃì计 俱计场 (璽计ぇ玡璽腹)玥穦玻ネ岿粇挡狦 狦 before 把计赣场だぇ┮惠玥 number 把计盢穦フ恶干オ娩 狦 after 把计籔 number 把计计场ぃ玥计盢砆彼き (┪箂恶干) 続ㄤ ﹚ 0 穦旧璓计砆彼き俱计
  4. exppexpt 把计北挡狦计场 expp 把计砞﹚计场竚计秖箇砞琌ㄏノ籔┮惠妓 (琌箂)expt 把计砞﹚ㄏノ计ボ猭牟祇翴 箇砞琌 precision 把计箇砞
  5. 狦 expp 琌 0玥ぃ矗ㄑ计计盢虏虫Αボ Τゲ璶杠穦箂狦 expp ⊿Τì镑计 玥穦玻ネ岿粇
  6. 狦俱计┪计场┮惠竚计秖だ禬 expt ┪ expt叫ㄏノ计ボ猭 狦 expt 琌 0玥﹚穦ㄏノ计ボ猭 埃獶计琌 0(狦 expp 琌 0玥穦竚传 expt  0 ) 狦讽 expp 砆﹚獶箂τ计琌 0 玥 expp+2 フ矗ㄑ挡狦计场狦计琌 0 ゼ﹚ expp玥盢ㄏノ虏虫Α

絛ㄒ

絛ㄒ 1

@DTW_FORMAT(NUM, BEFORE, result)

絛ㄒ 2

@DTW_FORMAT("1.73", "4", "0", result)

絛ㄒ 3

@DTW_FORMAT("1.73", "4", "3", result)

絛ㄒ 4

@DTW_FORMAT(" - 12.73", "", "4", result)

絛ㄒ 5

@DTW_FORMAT("12345.73", "", "", "2", "2", result)

絛ㄒ 6

@DTW_FORMAT("1.234573", "", "3", "", "0", result)

絛ㄒ 7

@DTW_rFORMAT(" - 12.73")

絛ㄒ 8

@DTW_rFORMAT("0.000")

絛ㄒ 9

@DTW_rFORMAT("12345.73", "", "", "3", "6")

絛ㄒ 10

@DTW_rFORMAT("1234567e5", "", "3", "0")

絛ㄒ 11

@DTW_rFORMAT("12345.73", "", "3", "", "0")


[ 郴狠 | 玡 |  | ヘ魁 | ま ]