Home > Database > Mysql Tutorial > mysql中取系统当前时间_MySQL

mysql中取系统当前时间_MySQL

WBOY
Release: 2016-05-30 17:11:05
Original
1458 people have browsed it

<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>
Copy after login

注意:sailing_date字段类型是Date类型,系统当前时间current_timestamp时间格式带时分秒的,所以需要将其转换成Date类型。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template