posts - 18,  comments - 0,  trackbacks - 0
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"
99    ;
posted on 2007-05-16 14:10 LORD BLOG 阅读(1716) 评论(0)  编辑  收藏 所属分类: 数据库相关

只有注册用户登录后才能发表评论。
网站导航:
 
Powered by:
BlogJava
Copyright ©2024 LORD BLOG