title: Splitting datetime into date/year/month/dayname and count year
body: <p>I got question to split date, month year, dayname from datetime by using trigger, when I insert a datetime, then in next column will split date, time, month year dayname and count year (to know how old the man in my data) is that possible ? </p>
  
  <p>For example, if I insert</p>
  
  <pre><code>INSERT INTO MAN VALUES ('04/06/1982')
  </code></pre>
  
  <p>then will be like this</p>
  
  <pre><code>DATETIME                  DATE         MONTH     YEAR      DAYNAME     AGE
  04/06/1982 00:00:00       04           06        1982      friday      27
  </code></pre>