ITeye博客

SQL

共 2 篇文章

Oracle——按时间段查询

按照多个时间段查询:包括秒 String sql = "from Sedimentpermit"; sql += " where Carno like '%" + carno + "%'"; sql += " and road like '%" + road + "%'"; sql += " and to_char(VALIDDATE,'yyyy-mm-dd') >= '" + validDate + "'"; sql += " and ((to_char(BEGINDATE1,'yyyy-mm-dd hh24:mi:ss') <= '" + time + "'"; sql += " and…

2012-07-31 15:34 · SQL

SQL语句

/*抄牌管理:CS_QW_TIEDANSB*/ select * from CS_QW_TIEDANSB where personguid ='1c7454cc-d6d0-4122-9b3f-d4cb993ebe9d' order by uptime desc /*拖车业务:CS_QW_TUOCHESB*/ select * from CS_QW_TUOCHESB where personguid ='1c7454cc-d6d0-4122-9b3f-d4cb993ebe9d' order by time desc /*现场纠处:CS_QW_XCJIUCHUSB*/ select * from…

2012-03-20 11:07 · SQL