MySQL convert datetime to Unix timestamp

Try this Query for CONVERT DATETIME to UNIX TIME STAMP

SELECT UNIX_TIMESTAMP(STR_TO_DATE('Apr 15 2012 12:00AM', '%M %d %Y %h:%i%p'))

This Query for CHANGE DATE FORMATE

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(STR_TO_DATE('Apr 15 2012 12:00AM', '%M %d %Y %h:%i%p')),'%m-%d-%Y %h:%i:%p')

SELECT UNIX_TIMESTAMP(STR_TO_DATE('30.1.2016', '%d.%m.%Y'))*1000;

-> '1454086800000'

SELECT FROM_UNIXTIME('1454086800','%d-%m-%Y %h:%i%p');

-> '30-01-2016 12:00AM'