date_format(NOW(),'%Y-%m-%d')
时间: 2024-01-23 22:02:45 浏览: 25
date_format(NOW(),'%Y-%m-%d')是一个MySQL的函数,用于将当前日期按照指定的格式进行转换。在这个例子中,'%Y-%m-%d'是日期格式的模板,其中%Y表示四位数的年份,%m表示两位数的月份,%d表示两位数的日期。所以该函数的作用就是将当前日期转换成'年-月-日'的格式。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [mysql中的DATE_FORMAT(NOW(),‘%Y-%m-%d‘)函数 --转载](https://blog.csdn.net/l1996729/article/details/111895082)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [详解mysql 获取当前日期及格式化](https://download.csdn.net/download/weixin_38621565/13698854)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]