GBase 8a MPP Cluster SQL参考手册
南大通用数据技术股份有限公司 III
3.3.23 LPAD(str,len,padstr) ............................. 81
3.3.24 LTRIM(str)....................................... 82
3.3.25 MAKE_SET(bits,str1,str2,...) ..................... 82
3.3.26 MID(str,pos,len) ................................. 84
3.3.27 NVL(string1,replace_with) ........................ 84
3.3.28 OCT(N) .......................................... 85
3.3.29 ORD(str) ........................................ 86
3.3.30 REPEAT(str,count) ................................ 87
3.3.31 REPLACE(str,from_str,to_str) ..................... 87
3.3.32 REVERSE(str) ..................................... 88
3.3.33 RIGHT(str,len) ................................... 88
3.3.34 RPAD(str,len,padstr) ............................. 89
3.3.35 RTRIM(str)....................................... 89
3.3.36 SUBSTRING() ...................................... 90
3.3.37 SUBSTRING_INDEX(str,delim,count) ................. 91
3.3.38 TO_CHAR(number,[FORMAT]) ......................... 92
3.3.39 TO_CHAR(datetime,[FORMAT]) ....................... 98
3.3.40 TO_NUMBER(expr) ................................. 110
3.3.41 TRANSLATE(char,from_string,to_string) ........... 111
3.3.42 TRIM ........................................... 112
3.3.43 UCASE(str)...................................... 114
3.3.44 UNHEX(str)...................................... 114
3.3.45 UPPER(str)...................................... 115
3.3.46 字符串转换类型函数 .............................. 116
3.3.47 expr LIKE pat [ESCAPE 'escape-char'] ............ 117
3.3.48 expr NOT LIKE pat [ESCAPE 'escape-char'] ........ 120
3.3.49 expr REGEXP pat, expr RLIKE pat ................. 121
3.3.50 expr NOT REGEXP pat, expr NOT RLIKE pat ......... 123
3.3.51 STRCMP(expr1,expr2) ............................. 124
3.3.52 正则表达式函数 .................................. 125
3.4 数值函数 ............................................. 134
3.4.1 算术操作符...................................... 135
3.4.2 数学函数 ....................................... 137
3.5 日期和时间函数 ....................................... 162
3.5.1 ADDDATE()....................................... 165
3.5.2 ADDTIME(expr,expr2) ............................. 165
3.5.3 ADD_MONTHS(date,number) ......................... 166
评论0