title: mysql date shows null
body: <p>I want to take today's dob and I used</p>
  
  <pre><code>select retailer_id
  from IPEX_LOAN_REGISTRATION_DETAILS
  where
  month(date_of_birth) = month(curdate()) 
  AND dayofmonth(date_of_birth) = dayofmonth(curdate());
  </code></pre>
  
  <p>as everyone has suggested. However, it doesn't show any birthday and I checked that there's one user who has birthday. So, I tried to check if I can take the month only, and I used</p>
  
  <pre><code>select month(date_of_birth) from IPEX_LOAN_REGISTRATION_DETAILS
  </code></pre>
  
  <p>and it showed me NULL data. Can anyone help me to solve this problem? Thank you.</p>