datastage 函数_DataStage常用函数大全.doc

DataStage常用函数大全

DataStage常用函数大全

DataStage常用函数大全1

一、类型转换函数4

1.Char4

2.DateToString4

3.DateToDecimal4

4.DecimalToDate5

5.DecimalToDecimal6

6.DecimalToDFloat6

7.DecimalToString7

8.DecimalToTime8

9.DecimalToTimestamp8

10.DFloatToDecimal9

11.DfloatToStringNoExp10

12.IsValidDate10

13.IsValidTime11

14.IsValidTimestamp11

15.RawNumAt11

16.RawToString12

17.Seq12

18.SeqAt12

19.StringToDate12

20.StringToDecimal13

21.StringToRaw13

22.StringToTime13

23.StringToTimestamp14

24.StringToUstring14

25.TimestampToDate14

26.TimestampToDecimal14

27.TimestampToString15

28.TimestampToTime16

29.TimeToString16

30.TimeToDecimal16

31.UstringToString17

二、字符串函数17

32.AlNum17

33.Alpha17

34.CompactWhiteSpace18

35.Compare18

36.CompareNoCase18

37.CompareNum18

38.CompareNumNoCase19

39.Convert19

40.Count19

41.Dcount19

42.DownCase20

43.DQuote20

44.Field20

45.Index20

46.Left21

47.Len21

48.Num21

49.PadString21

50.Right21

51.Soundex22

52.Space22

53.SQuote22

54.Str22

55.StripWhiteSpace23

56.Trim23

57.TrimB24

58.TrimF24

59.TrimLeadingTrailing24

60.UpCase24

三、数字函数25

61.AsDouble25

62.AsFloat25

63.AsInteger25

64.MantissaFromDecimal26

65.MantissaFromDFloat26

四、日期和时间函数26

66.CurrentDate26

67.CurrentTime27

68.CurrentTimeMS27

69.CurrentTimestamp27

70.CurrentTimestampMS27

71.DateFromDaysSince27

72.DateFromComponents28

73.DateFromJulianDay28

74.DateOffsetByComponents28

75.DaysSinceFromDate29

76.DaysInMonth29

77.DaysInYear29

78.DateOffsetByDays30

79.HoursFromTime30

80.JulianDayFromDate30

81.MicroSecondsFromTime30

82.MidnightSecondsFromTime31

83.MinutesFromTime31

84.MonthDayFromDate31

85.MonthFromDate31

86.NextWeekdayFromDate32

87.NthWeekdayFromDate32

88.PreviousWeekdayFromDate32

89.SecondsFromTime32

90.SecondsSinceFromTimestamp33

91.TimeDate33

92.TimeFromComponents33

93.TimeFromMidnightSeconds33

94.TimeOffsetByComponents34

95.TimeOffsetBy