神通数据库支持的函数特性¶
神通数据库支持的函数特性可以通过查询系统视图 v_sys_scalarfunc_info 获取， 具体取值如下:
| 特性名 | 特性值 | 描述 |
|---|---|---|
| CONVERT_FUNCTIONS | 1 | 数据库支持的格式转化函数(SQL_FN_CVT_CONVERT: 0x00000001L,SQL_FN_CVT_CAST: 0x00000002L) |
| NUMERIC_FUNCTIONS | 1048575 | 数据库支持的数值函数(SQL_FN_NUM_ABS:0x00000001L,SQL_FN_NUM_ACOS:0x00000002L,SQL_FN_NUM_ASIN:0x00000004L,SQL_FN_NUM_ATAN:0x00000008L,SQL_FN_NUM_ATAN2:0x00000010L,SQL_FN_NUM_CEILING: 0x00000020L,SQL_FN_NUM_COS:0x00000040L,SQL_FN_NUM_COT:0x00000080L,SQL_FN_NUM_EXP:0x00000100L,SQL_FN_NUM_FLOOR: 0x00000200L,SQL_FN_NUM_LOG:0x00000400L,SQL_FN_NUM_MOD:0x00000800L,SQL_FN_NUM_SIGN:0x00001000L,SQL_FN_NUM_SIN:0x00002000L,SQL_FN_NUM_SQRT:0x00004000L,SQL_FN_NUM_TAN:0x00008000L,SQL_FN_NUM_PI: 0x00010000L,SQL_FN_NUM_RAND:0x00020000L,SQL_FN_NUM_DEGREES: 0x00040000L,SQL_FN_NUM_LOG10:0x00080000L,SQL_FN_NUM_POWER:0x00100000L,SQL_FN_NUM_RADIANS:0x00200000L,SQL_FN_NUM_ROUND:0x00400000L,SQL_FN_NUM_TRUNCATE: 0x00800000L) |
| STRING_FUNCTIONS | 15646717 | 数据库支持的字符串函数(SQL_FN_STR_CONCAT: 0x00000001L,SQL_FN_STR_INSERT: 0x00000002L,SQL_FN_STR_LEFT: 0x00000004L,SQL_FN_STR_LTRIM:0x00000008L,SQL_FN_STR_LENGTH:0x00000010L,SQL_FN_STR_LOCATE:0x00000020L,SQL_FN_STR_LCASE: 0x00000040L,SQL_FN_STR_REPEAT: 0x00000080L,SQL_FN_STR_REPLACE: 0x00000100L,SQL_FN_STR_RIGHT: 0x00000200L,SQL_FN_STR_RTRIM: 0x00000400L,SQL_FN_STR_SUBSTRING: 0x00000800L,SQL_FN_STR_UCASE: 0x00001000L,SQL_FN_STR_ASCII: 0x00002000L,SQL_FN_STR_CHAR:0x00004000L,SQL_FN_STR_DIFFERENCE: 0x00008000L,SQL_FN_STR_SOUNDEX: 0x00020000L,SQL_FN_STR_SPACE: 0x00040000L,SQL_FN_STR_BIT_LENGTH: 0x00080000L,SQL_FN_STR_CHAR_LENGTH: 0x00100000L,SQL_FN_STR_CHARACTER_LENGTH: 0x00200000L,SQL_FN_STR_OCTET_LENGTH: 0x00400000L,SQL_FN_STR_POSITION: 0x00800000L) |
| SYSTEM_FUNCTIONS | 4 | 数据库支持的系统函数(SQL_FN_SYS_USERNAME: 0x00000001L,SQL_FN_SYS_DBNAME: 0x00000002L,SQL_FN_SYS_IFNULL:0x00000004L) |
| TIMEDATE_ADD_INTERVALS | 160 | 时间间隔函数TIMESTAMPADD中可以使用的时间间隔类型(SQL_FN_TSI_FRAC_SECOND: 0x00000001L,SQL_FN_TSI_SECOND:0x00000002L,SQL_FN_TSI_MINUTE:0x00000004L,SQL_FN_TSI_HOUR:0x00000008L,SQL_FN_TSI_DAY:0x00000010L,SQL_FN_TSI_WEEK:0x00000020L,SQL_FN_TSI_MONTH:0x00000040L,SQL_FN_TSI_QUARTER:0x00000080L,SQL_FN_TSI_YEAR:0x00000100L) |
| TIMEDATE_DIFF_INTERVALS | 160 | 时间间隔函数TIMESTAMPDIFF中可以使用的时间间隔类型(SQL_FN_TSI_FRAC_SECOND: 0x00000001L,SQL_FN_TSI_SECOND:0x00000002L,SQL_FN_TSI_MINUTE:0x00000004L,SQL_FN_TSI_HOUR:0x00000008L,SQL_FN_TSI_DAY:0x00000010L,SQL_FN_TSI_WEEK:0x00000020L,SQL_FN_TSI_MONTH:0x00000040L,SQL_FN_TSI_QUARTER:0x00000080L,SQL_FN_TSI_YEAR: 0x00000100L) |
| TIMEDATE_FUNCTIONS | 123615 | 数据库支持的时间函数(SQL_FN_TD_NOW: 0x00000001L,SQL_FN_TD_CURDATE:0x00000002L,SQL_FN_TD_DAYOFMONTH: 0x00000004L,SQL_FN_TD_DAYOFWEEK: 0x00000008L,SQL_FN_TD_DAYOFYEAR: 0x00000010L,SQL_FN_TD_MONTH: 0x00000020L,SQL_FN_TD_QUARTER:0x00000040L,SQL_FN_TD_WEEK: 0x00000080L,SQL_FN_TD_YEAR: 0x00000100L,SQL_FN_TD_CURTIME:0x00000200L,SQL_FN_TD_HOUR:0x00000400L,SQL_FN_TD_MINUTE: 0x00000800L,SQL_FN_TD_SECOND: 0x00001000L,SQL_FN_TD_TIMESTAMPADD: 0x00002000L,SQL_FN_TD_TIMESTAMPDIFF: 0x00004000L,SQL_FN_TD_DAYNAME: 0x00008000L,SQL_FN_TD_MONTHNAME: 0x00010000L,SQL_FN_TD_CURRENT_DATE: 0x00020000L,SQL_FN_TD_CURRENT_TIME: 0x00040000L,SQL_FN_TD_CURRENT_TIMESTAMP:0x00080000L,SQL_FN_TD_EXTRACT:0x00100000L) |