How to do this Birthdays in the next two weeks using Responsys MYSQL

Asked May 10 '19 at 08:35

Active May 10 '19 at 09:22

Viewed 77 times

I'm setting up a segment using SQL and I need to capture contacts that birthday will be 15 days from now.

SELECT   *
FROM     $A$
WHERE EXTRACT(month FROM BIRTHDATE) = EXTRACT(month FROM CURRENT_TIMESTAMP)
AND EXTRACT(day FROM BIRTHDATE) = EXTRACT(day FROM CURRENT_TIMESTAMP - 15)

edited May 10 '19 at 09:22

sassy_rog

1,077
12
30

asked May 10 '19 at 08:35

Peter

1

Check: https://stackoverflow.com/questions/28802351/mysql-where-date-15-days – KIKO Software May 10 '19 at 08:44
Possible duplicate of [MySQL WHERE Date > 15 Days](https://stackoverflow.com/questions/28802351/mysql-where-date-15-days) – John M May 10 '19 at 09:43

How to do this Birthdays in the next two weeks using Responsys MYSQL

0 Answers0