title: In Oracle SQL, compare string date column with today's date. Considering only Month and Day
body: <p>I have a user table in which the birthdate Column is string type with date <strong>pattern = '19910511' (YYYYMMDD)</strong>. How can i compare this column with today's date only using Month and day. The problem is the pattern of birthdate column.
  I have tried something like this:</p>
  
  <pre><code>SELECT UDATANASCIMENTO as birthDate FROM USERS WHERE to_char(UDATANASCIMENTO, 'MMDD') = to_char(sysdate, 'MMDD')
  </code></pre>
  
  <p>But it doesn't work as the formating is the issue. Any ideas please ?</p>