framework/resources/Functional/aggregates/aggregation/group_by_expression/extract_month_day_from_timestamp_with_concat.sql

select  
	concat(cast(extract(day from c_timestamp) as varchar(10)), '-', cast(extract(month from c_timestamp) as varchar(10)),'-',cast(extract(year from c_timestamp) as varchar(10))),
	sum(c_integer)	as sum1,
	sum(c_smalldecimal) as sum2,
	sum(c_bigdecimal) as sum3,
	sum(c_float) as sum4,
	sum(c_bigint - c_integer) as sum5,
	avg(c_bigint) as avg1,
	avg(c_integer) as avg2,
	avg(c_smalldecimal) as avg3
from 
	alltypes  
group by 
	concat(cast(extract(day from c_timestamp) as varchar(10)), '-', cast(extract(month from c_timestamp) as varchar(10)),'-',cast(extract(year from c_timestamp) as varchar(10)))
order by
	concat(cast(extract(day from c_timestamp) as varchar(10)), '-', cast(extract(month from c_timestamp) as varchar(10)),'-',cast(extract(year from c_timestamp) as varchar(10)))
;