Redshift epoch

Source: Redshift Epochs and Timestamps

1 2 3 4

select rating_date, extract('epoch' from rating_date::timestamp) as rating_date_epoch from eu_db1.ft_rated_cdr where extract('epoch' from cdr_date::timestamp) = 1561504138 and charged_co_id = 296661