PHP: Insert Date Into MSSQL DB

Hello Experts,

Very simple... i would like to enter the current date & time into my MS SQL DB, Field: LastMapUpdate using PHP.

My existing code is below, please advise how to modify for the desired results.

Thanks in advance.

$sql = sprintf("UPDATE Routes SET EstDistance=%f, EstHours=%d, " .
			"EstMins=%d, FinishDate='%s', FinishTime='%s', ReMap=0 WHERE ID=%d",
			$cmdObject->totaldist, $cmdObject->totalhours, $cmdObject->totalmins,
			$runfinishdate, $cmdObject->runfinishtime, $cmdObject->runid);
		$res = $MyDB->ExecQuery($sql);

Select all Open in new window