mysql中取系统当前时间

<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类型。

 

转载于:https://www.cnblogs.com/vanl/p/4833312.html