First day of a month in MySql

57
Views
1
Answers

How to get the first day of a month in MySql?

edit | flag
William Patrick
Asked on: Jul 27, 2011 at 8:14PM

1 Answers

52
4
52

Try this..

select DATE_FORMAT(CONCAT(SUBSTR(NOW(),1,8),'01'),'%a');
edit | flag
Gokul A
Answered on: Jul 27, 2011 at 8:15PM

Post your Answer

Search

Welcome to Ask Amoeba!
This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions.
Learners, beginners, Experts stop and share your knowledge and ideas!

Browse Categories

Browse Tags