Tag: date_trunc

php:

$date = date("Y-m-d H:i:s",strtotime($line[modif]));
echo $date;

sql:

select date_trunc('second', now()::timestamp without time zone)