I have `tbl1` which has field `date` and `time`.Suppose there's another table `tbl2` with field `date_time`.Now,I want to take data from `date` & `time` field of `tbl1`,combine them and insert to `date_time` field of `tbl2`,in `Y-m-d H:i:s` format or which ever format possible.Please some one help,inserting from one table to another isn't a problem but combining value of two field then inserting to another table is making me headache?