Data transformation and processing in MySQL for later BI use

I have some data that is inserted into MySQL via a windows service, this data has a Date column which I need to be arranged into a certain format, extract the Year, month and month number. Then I also need a trigger that'll insert data into a table, on update or insert of a source table.