您好,欢迎访问一九零五行业门户网

mysql中取系统当前时间_MySQL

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
注意:sailing_date字段类型是date类型,系统当前时间current_timestamp时间格式带时分秒的,所以需要将其转换成date类型。
其它类似信息

推荐信息