select function alias

Howdy,

I've a series of timestamp columns I'd like to alias in select statements.
psql indicates my alias doesnt exist after
I define it.

Example -> select to_char(impressions_create_date,'yyyy-mm-dd') as ymd from
impressionsdb where ymd like '2016-11%' ;

psql always complains column ymd does not exist. I've inherited a series of
tables with many timestamps and would like to
shorten the select in queries without renaming any columns.

postgresql 9.2 on Gentoo 4.4.26

TIA, TRB