Re: select function alias

5. Use a CTE:

    with shortnames as (

        select to_char(impressions_create_date,'yyyy-mm-dd') as ymd from impressionsdb 

) select ymd from shortnames where ymd like '2016-11%';