concate year_month_day from different column

[Anonymous]

hello,

i have a table which is having year,month, date column .

i want to concate this column into one single date column,

please help..

this type of column in my input table.:- 

 

Thanks in advance

Regards,

Manish 

[Anonymous]

Hi Manish,

You can concatenate with "+" operator

e.g: month+"-"+day+"-"+year

Regards..

[iamabhishek]

How do you want to concat them, what would be your expected output format?