E
E
Evgeny Rebrov2019-06-20 15:14:55
Google Cloud Platform
Evgeny Rebrov, 2019-06-20 15:14:55

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 question

Ask a Question

731 491 924 answers to any question