peachyontop

Registry Date [ IGNORE ]

May 28th, 2025
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. CASE
  2. WHEN dateDiff('day', full_reg_datetime, date_of_action) = 0 THEN 'A. 0 Day'
  3. WHEN dateDiff('day', full_reg_datetime, date_of_action) = 1 THEN 'B. 1 Day'
  4. WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 7 THEN 'C. 2-7 Day'
  5. WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 30 THEN 'D. 8-30 Day'
  6. WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 89 THEN 'E. 2-3 month'
  7. WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 179 THEN 'F. 4-6 month'
  8. WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 364 THEN 'G. 7-12 month'
  9. WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 729 THEN 'H. 1-2 years'
  10. ELSE 'I. > 2 years'
  11. END AS registration_age_group
  12.  
Advertisement
Add Comment
Please, Sign In to add comment