摘要: select current_date() from dual; select current_time() from dual; select current_timestamp() from dual; select date_add(now,interval 10 minute) from d 阅读全文
posted @ 2022-04-05 15:03 ascertain 阅读(29) 评论(0) 推荐(0) 编辑
摘要: select abs(-5) from dual; select bin(10) from dual; # 转二进制 1010 select hex(100) from dual; select conv(number,from_base,to_base) select ceil(n) select 阅读全文
posted @ 2022-04-05 14:23 ascertain 阅读(27) 评论(0) 推荐(0) 编辑
摘要: select charset(str); # 显示客户端字符集 select charset(field1) from table; # field1字符集 select charset(field2) from table; # field2字符集 concat(str1,str2,...); i 阅读全文
posted @ 2022-04-05 14:09 ascertain 阅读(28) 评论(0) 推荐(0) 编辑