KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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
Tags (comma-separated)
Save Edits
Cancel