<?php

$date = new DateTime();
$date->setTimezone(new DateTimeZone('America/Sao_Paulo'));

$query = "INSERT INTO table (`name`, `date`) VALUES ('Nome', '{$date->format('Y-m-d H:i:s')}')";

echo $query;