select Cast( '2021-09-22' as date ) as castedDate; select convert(date,'20210922') as convertedDate;
select * from test a, test b where a.t = b.t (+)