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

 

原标题：mysql中取系统当前时间

关键词：MYSQL