如何在mysql中获得每个相应月份的第一天? [英] How to get first day of every corresponding month in mysql?
本文介绍了如何在mysql中获得每个相应月份的第一天?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请帮助我如何计算从选定日期开始的第一天。目前,我正在尝试使用以下mysql select query获得需求:
选择
DAYOFMONTH(hrm_attendanceregister.Date)> ; =
DAYOFMONTH(
DATE_SUB('2010-07-17',INTERVAL - DAYOFMONTH('2010-07-17')+ 1 DAY
)
FROM
hrm_attendanceregister;
感谢
解决方案
这是你正在寻找的:
选择CAST(DATE_FORMAT(NOW() %Y-%m-01')作为DATE);
I want to get first day of every corresponding month of current year. For example, if user selects '2010-06-15', query demands to run from '2010-06-01' instead of '2010-06-15'.
Please help me how to calculate first day from selected date. Currently, I am trying to get desirable using following mysql select query:
Select
DAYOFMONTH(hrm_attendanceregister.Date) >=
DAYOFMONTH(
DATE_SUB('2010-07-17', INTERVAL - DAYOFMONTH('2010-07-17') + 1 DAY
)
FROM
hrm_attendanceregister;
Thanks
解决方案
Is this what you are looking for:
select CAST(DATE_FORMAT(NOW() ,'%Y-%m-01') as DATE);
这篇关于如何在mysql中获得每个相应月份的第一天?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文