DataStage常用函数大全

DataStage 常用函数大全DATASTAGE 常用函数大全 1一、类型转换函数 41.Char42.DateToString43.DateToDecimal44.DecimalToDate55.DecimalToDecimal66.DecimalToDFloat67.DecimalToString78.DecimalToTime89.DecimalToTimestamp810.DFloatToDecimal911.DfloatToStringNoExp1012.IsValidDate1013.IsValidTime1114.IsValidTimestamp1115.RawNumAt1116.RawToString1217.Seq1218.SeqAt1219.StringToDate1220.StringToDecimal1321.StringToRaw1322.StringToTime1323.StringToTimestamp1424.StringToUstring1425.TimestampToDate1426.TimestampToDecimal1427.TimestampToString1528.TimestampToTime1629.TimeToString1630.TimeToDecimal1631.UstringToString17二、字符串函数 1732.AlNum1733.Alpha1734.CompactWhiteSpace1835.Compare1836.CompareNoCase1837.CompareNum1838.CompareNumNoCase1939.Convert1940.Count1941.Dcount1942.DownCase2043.DQuote2044.Field2045.Index2046.Left2147.Len2148.Num2149.PadString2150.Right2151.Soundex2252.Space2253.SQuote2254.Str2255.StripWhiteSpace2356.Trim2357.TrimB2458.TrimF2459.TrimLeadingTrailing2460.UpCase24三、数字函数 2561.AsDouble2562.AsFloat2563.AsInteger2564.MantissaFromDecimal2665.MantissaFromDFloat26四、日期和时间函数 2666.CurrentDate2667.CurrentTime2768.CurrentTimeMS2769.CurrentTimestamp2770.CurrentTimestampMS2771.DateFromDaysSince2772.DateFromComponents2873.DateFromJulianDay2874.DateOffsetByComponents2875.DaysSinceFromDate2976.DaysInMonth2977.DaysInYear2978.DateOffsetByDays3079.HoursFromTime3080.JulianDayFromDate3081.MicroSecondsFromTime3082.MidnightSecondsFromTime3183.MinutesFromTime3184.MonthDayFromDate3185.MonthFromDate3186.NextWeekdayFromDate3287.NthWeekdayFromDate3288.PreviousWeekdayFromDate3289.SecondsFromTime3290.SecondsSinceFromTimestamp3391.TimeDate3392.TimeFromComponents3393.TimeFromMidnightSeconds3394.TimeOffsetByComponents3495.TimeOffsetBySeconds3496.TimestampFromDateTime3497.TimestampFromSecondsSince3498.TimestampFromTimet3599.TimestampOffsetByComponents35100.TimestampOffsetBySeconds35101.TimetFromTimestamp36102.WeekdayFromDate36103.YeardayFromDate36104.YearFromDate36105.Year...