troubleshooting Question

PHP: Insert Date Into MSSQL DB

Avatar of davecestria
davecestria asked on
4 Comments3 Solutions1220 ViewsLast Modified:
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);

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros