Converting DATETIME to Unixtimestamp

I have a situation where useres are entering a date in a DATETIME column, and I need to convert it to UNIX timestamp in another column.
Any suggestions?