TO_CHAR("BLOCK_TIMESTAMP", 'YYYY-MM-DD') as "Bend Was Officially Implemented On",

CASE

WHEN DATEDIFF('day', "Bend Was Officially Implemented On", CURRENT_DATE()) > 7 AND DATEDIFF('day', "Bend Was Officially Implemented On", CURRENT_DATE()) < 30 THEN CONCAT(DATEDIFF('week', "Bend Was Officially Implemented On", CURRENT_DATE()), ' Weeks')

WHEN DATEDIFF('day', "Bend Was Officially Implemented On", CURRENT_DATE()) > 30 THEN CONCAT(DATEDIFF('month', "Bend Was Officially Implemented On", CURRENT_DATE()), ' Months')

END as "Bend Has Been Running For"

from ethereum.core.fact_transactions

where "TX_HASH" = lower('0xd8031ea1ccecfd439db8ce4c5ca9905e208a0e6699b6088c32bddcd4697e43c1')