Sybase IQ 12.6常用函数

1aggregate_func_name
2 : "sum" | "求和"
3 | "avg" | "求平均数"
4 | "max" | "求最大值"
5 | "min" | "求最小值"
6 | "count" | "求记录数"
7 ;
8
9number_function
10 : "abs" | "取绝对值"
11 | "acos" | "求值的余弦角"
12 | "asin" | "求值的正弦角"
13 | "atan" | "求值的正切角"
14 | "atin2" | "求值的正弦和余弦角"
15 | "ceiling" | "求五入后的整数"
16 | "cos" | "求角的余弦值"
17 | "cot" | "求角的余切值"
18 | "degrees" | "求弧度数的角大小"
19 | "exp" | "求幂值"
20 | "floor" | "求四舍后的整数"
21 | "log" | "求自然对数"
22 | "log10" | "求10为底的对数"
23 | "mod" | "求模"
24 | "pi" | "求PI"
25 | "power" | "求数字的次幂值"
26 | "radians" | "求度数角的弧度"
27 | "rand" | "求0和1间的随机数"
28 | "round" | "格式化数值"
29 | "sign" | "求值的符号"
30 | "sin" | "求角的正弦值"
31 | "sqrt" | "求平方根"
32 | "tan" | "求角的正切值"
33 ;
34
35string_function
36 : "ascii" | "求第一个字符的ASCII码"
37 | "char" | "求等值的字符"
38 | "char_length" | "求字符串的长度"
39 | "charindex" | "存在于"
40 | "difference" | "求两个串的差值"
41 | "lcase"
42 | "left" | "字符串左截"
43 | "length" | "求字符串总长度"
44 | "lower" | "将字符串转为小写"
45 | "ltrim" | "去掉左空格"
46 | "patindex" | "求第一次出现位置"
47 | "replace" | "字符串替换"
48 | "right" | "字符串左截"
49 | "rtrim" | "去掉右空格"
50 | "str" | "数值转字符串"
51 | "substring" | "字符串截取"
52 | "upper" | "将字符串转为大写"
53 ;
54
55datetime_function
56 : "dateformat" | "格式化日期"
57 | "datename" | "求日期的分量值"
58 | "datepart" | "求日期的分量整数值"
59 | "datetime" | "转为日期时间"
60 | "date"
61 | "dayname"
62 | "days"
63 | "day"
64 | "dow"
65 | "hours"
66 | "hour"
67 | "minutes"
68 | "minute"
69 | "monthname"
70 | "months"
71 | "month"
72 | "now" | "取当前日期时间"
73 | "quarter"
74 | "seconds"
75 | "second"
76 | "today" | "取当前日期"
77 | "weeks"
78 | "

week"
79 | "years"
80 | "year"
81 | "getdate" | "求当前日期时间"
82 | "dateadd" | "日期相加"
83 | "datediff" | "日期相减"
84 ;
85
86conversion_function
87 : "convert" | "字符转为日期"
88 | "hextoint" | "十六进制转为整数"
89 | "inttohex" | "整数转为十六进制"
90 | "isdate" | "是日期型"
91 | "isnumeric" | "是数值型"
92 ;
93
94system_function
95 : "suser_id"
96 | "suser_name"
97 | "user_id"
98 | "user_name"