Home >Database >Mysql Tutorial >to_char()多了个字符
to_char()多了个字符
- WBOYOriginal
- 2016-06-07 15:23:051357browse
sp.param_value nvarchar2(200); select sp.param_code, to_number(sp.param_value), sp.param_value,length(param_value) 为什么to_char不行呢？ 不带格式的是3个字符 难怪查不到数据呢！！ 而这种直接单引号就行 所以 and sp.param_value = trim(to_char(0
sp.param_value nvarchar2(200);
select sp.param_code, to_number(sp.param_value), sp.param_value,length(param_value)
为什么to_char不行呢？
不带格式的是3个字符
难怪查不到数据呢！！
而这种直接单引号就行
所以 and sp.param_value = trim(to_char(0.78,'0.00')) 就行了
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：NoSQL数据库一一介绍Next article：sharedpool之二：freelists/sharedpoollrulist