转换为时间戳格式

Question

I have a date in the this format : Aug 18, 2014 15:30:35.246263000
I want to convert this format to timestamp i.e 2014-8-18 15:30:35. I don't know how timestamp handle milliseconds. I am using PHP and MySql.

Answer 1

Like scragar said, you can't convert exactly your date to a unix timestamp, since the timestamp doesn't support milliseconds. You can however trim the milliseconds and use strtotime, like such:

$time  = 'Aug 18, 2014 15:30:35.246263000';
$parts = explode('.', $time);
$timestamp = strtotime($parts[0]);

Good luck!