<select id="getFreightEfclInventoryList" parameterType="long" resultMap="BaseResultMap1">
SELECT
freight_efcl_inventory_id,
freight_efcl_id,
closing_date,
sailing_date,
shipping_space_total,
shipping_space_remain,
shipping_space_used
FROM
freight_efcl_inventory
WHERE
1=1
AND freight_efcl_id=#{freightEfclId}
AND sailing_date >= DATE(current_timestamp)
ORDER BY
sailing_date ASC
limit 4
</select>
注意：sailing_date字段类型是Date类型，系统当前时间current_timestamp时间格式带时分秒的，所以需要将其转换成Date类型。
mysql中取系统当前时间
原文：http://www.cnblogs.com/vanl/p/4833312.html
