![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
db
applejian
这个作者很懒,什么都没留下…
展开
-
关于两个日期间隔工作日的oracle sql实现
sysdate是系统时间 xx.dd是从数据库表中取出的时间,执行结果取出所有当前系统时间在5个工作日以后的结果集。 select * from tableName where (trunc(sysdate -x.dd) - ((case WHEN (8 - to_number(to_char(x.dd, 'D'))) >trunc(sysdate - x.dd) ...原创 2011-10-07 00:12:14 · 352 阅读 · 0 评论 -
MySQL创建方法错误:This function has none of DETERMINISTIC, NO SQL
创建function时 出错信息: ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe l...原创 2011-12-22 16:04:17 · 94 阅读 · 0 评论