技术-mysql-时间的语句

1.sql语句：

eatMedTime:数据库只存时分秒：6:00；

本句话意思为:查询系统当前时间的前十分钟范围内的有关数据

select

eatMedTime,
eatMedId,
o.ownerId AS ownerId,
o.ownerName AS ownerName,
eatmed.medName AS medName
from eatmed
LEFT JOIN `owner` o ON o.ownerId = eatmed.ownerId
where eatMedSwitch='1'


and  ADDDATE(DATE_FORMAT(CONCAT(DATE_FORMAT(CURRENT_DATE(),'%Y-%m-%d') ,' ',eatMedTime),'%Y-%m-%d %H:%i:%s'),INTERVAL -10 MINUTE ) <=


DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:00')
AND


DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:00') <=


DATE_FORMAT(CONCAT(DATE_FORMAT(CURRENT_DATE(),'%Y-%m-%d') ,' ',eatMedTime),'%Y-%m-%d %H:%i:%s')


<isNotNull property="agencyId" prepend="and ">
o.agencyId = #agencyId#
</isNotNull>

order by eatMedTime

2.时间控件只取时分秒：注：

注：id为datetimepicker每隔jsp中只能有一个，取出来时间以String类型存入数据库中。

@Styles.Render("~/Content/themes/default/bootstrap-datetimepicker.css")
@Scripts.Render("~/Scripts/bootstrap-datetimepicker.js")
@Scripts.Render("~/Scripts/bootstrap-datetimepicker.zh-CN.js")

<div class="container" style="padding: 0 15px;">  
   <small>时间 </small>
     <input type="text"  id="datetimepicker">
</div>

<script type="text/javascript">
    $(function () {
        $('#datetimepicker').datetimepicker({
            format: 'hh:ii',
            startView:1
        });
    });
</script>

有关时间的问题：http://www.cnblogs.com/xcsn/p/3375116.html

可参考此微博。