当前位置：网站首页>[MySQL] current date minus one day field year month day -1 day

[MySQL] current date minus one day field year month day -1 day

2022-07-21 05:42:00 【CTRA Wang dada】

1、mysql Data sheet & Business needs

We need to be right about varchar Type field , MM DD YY date -1 Day operation
Insert picture description here

2、 Brush date minus 1 Day method

Format here ：‘%Y-%m-%d’ The format of the generated string is 2022-07-11 In this way , If you don't need such , You can check the string you want by yourself

UPDATE report_spent SET cost_date=DATE_FORMAT(DATE_SUB(cost_date,INTERVAL 1 DAY),'%Y-%m-%d');

原网站

版权声明
本文为[CTRA Wang dada]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/202/202207200827367980.html

边栏推荐

【mysql】当前日期减一天字段年月日-1天
R 语言作业三
刚入门软件测试行业的女生就能月薪过万骗局解秘
PHP registration user requirements
工业4.0数字孪生下的应用案例
(第二章一一栈与队列)第三节队列的顺序存储结构
什麼是棧？
Tp5.1 controller initialization initialize (inherit public file initialization)
Iptables firewall experiment
Tp5.1 open the web address and output the web page code without transformation and rendering (template return $this- & gt; fetch() return view();)

当前位置：网站首页>[MySQL] current date minus one day field year month day -1 day

[MySQL] current date minus one day field year month day -1 day

1、mysql Data sheet & Business needs

2、 Brush date minus 1 Day method

边栏推荐

猜你喜欢

随机推荐