Answer the question
In order to leave comments, you need to log in
How to display a list with users who have DR today?
sql bigquery has its own peculiarities, so the MySQL examples don't work. Task: display a list of users who have AR today. The birthday is stored in the 'birthday' field and has a date value of '2019-06-20'.
Every day I will need to get a list of users with DR for the current date.
for MySQL they offered this option: WHERE DATE_FORMAT(`date`, '%m%d') = DATE_FORMAT(CURDATE(), '%m%d')
but there is no DATE_FORMAT in GBQ. tried through EXTRACT, something does not work.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question