SELECT TIMESTAMP(year + '-' + month + '-' + day) as output_timestamp FROM (
SELECT REGEXP_EXTRACT(date, '.*/([0-9]{4})$') as year,
REGEXP_EXTRACT(date, '^([0-9]{2}).*') as day,
REGEXP_EXTRACT(date, '.*/([0-9]{2})/.*') AS month
FROM (
SELECT STRFTIME_UTC_USEC(date, "%d/%m/%Y") as date FROM (TABLE_DATE_RANGE([[97466444.ga_sessions_], DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'),DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'))), (TABLE_DATE_RANGE([97466444.ga_sessions_intraday_], DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'), DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'))) group by date order by date desc
)
)