joseramoncajide
12/14/2017 - 12:34 PM

dates.sql

dates.sql
content_copyfile_download
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

    )
)