简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

mysql中取系统当前时间_MySQL

WBOY
Release： 2016-05-30 17:11:05
Original
1363 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：
time system
source：php.cn
Previous article：MySQL联合查询_MySQL Next article：MySQL 5.6 root密码丢失，使用mysqld --skip-grant-tables_MySQL
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
Latest Articles by Author
Latest Issues
How to make table cell values ​​hyperlinked in Dash? (Using Plotly, Dash, Pandas, etc.) I want to set the cell value under the "JobLink" column as a hyperlink. When I c...
From 2023-11-17 18:47:10
0
1
283
Module is not defined in Vue project I just created a new Vue application by running npmini tvue@latest as specified in the off...
From 2023-11-17 12:38:53
0
2
394
Eliminate notification in WooCommerce stating "Checkout cannot be done when cart is empty". What code should I add in functions.php to remove "Cannot checkout when cart is empty...
From 2023-11-17 11:41:02
0
1
361
How to pass key as select option value in v-for when changed (VueJS) I'm using Vue3 and Bootstrap5. I have a select with multiple options. Now I am displaying ...
From 2023-11-17 08:55:24
0
1
276
Nuxt.js SSG (Static Site Generator) Get API Data When building a project using a static site generator, I understand that documentation cre...
From 2023-11-16 21:36:07
0
1
176
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！