全文検索
edit
$tp = Time::Piece->strptime(substr('2010-05-18 14:56:44.675572+09',0, 19), '%Y-%m-%d %H:%M:%S');