<select id="queryLiveInfo" resultMap="BaseResultMap" parameterType="java.util.Map" >
select
id,liveId,liveListId,isTaped,ProgramListDate,startTime,endTime,title,length,sCover,cover,status,activityId,adapter,ext
from Live_Program_Info
where liveId=( #{liveId,jdbcType=VARCHAR}) and <![CDATA[ unix_timestamp(startTime) <= unix_timestamp(#{time,jdbcType=DATE}) ]]> and <![CDATA[ unix_timestamp(startTime) <= unix_timestamp(#{time,jdbcType=DATE}) ]]>
</select>
mybatis 时间查询
最新推荐文章于 2024-09-10 10:21:38 发布