如何在Presto SQL中将unix时间戳转换为日期并从中提取月份

我有以下查询：

    select cast(ov.ingestion_timestamp as date), date(ov.date_id), cast(ov.main_category as varchar), 
    sum(cast(ov.order_target as int)),
    sum(cast(ov.gmv_target as int))
    from tableA ov 
    inner join tableB cb
    on date(ov.date_id) = date(cb.ingestion_timestamp)
    inner join tableC loc  
    on date(ov.date_id) = date(loc.ingestion_timestamp)
    where MONTH(date(ov.ingestion_timestamp)) = month(current_date)
group by 1,2,3

我想获取ingestion_timestamp列的月份等于当前月份的记录。所有列值都存储为对象，因此我需要转换为它们各自的数据类型。我可以知道如何获取ingestion_timestamp列的月份吗？

谢谢。