Thanks. Tried the below conversion value and it worked in snowflake( Source :UTC to EST time zone):

select competitor_offer_date, CONVERT_TIMEZONE('UTC','EST',competitor_offer_date::TIMESTAMP_NTZ) as Competitor_offer_date_updt, from zeus.competitor_price_offer limit 50 ;