sprintf() with date string

[PCHomepage]

I'm trying to insert a date/time to MySQL using sprintf() but can't seem to work out how to do it. The date and time are formatted as 2014-10-01 09:30:00 but I'm not sure how to format the data to insert it. I tried '%04d-%02d-%02d %02d:%02d:%02d' but get an error of too few arguments. What am I doing wrong?

$PostID = (isset($_POST["ID"]) && !empty($_POST["ID"])) ? $_POST["ID"] : "";
$Title = (isset($_POST['Title'])) ? $_POST['Title'] : NULL;
$StartDate = (isset($_POST['StartDate'])) ? $_POST['StartDate'] : NULL;
$StartTime = (isset($_POST['StartTime'])) ? $_POST['StartTime'] : NULL;
$FormattedDateTime = "$StartDate $StartTime";
$FormattedDateTime = date('Y-m-d H:i:s', strtotime($FormattedDateTime));

// Insert record
if (isset($_POST) && (isset($_POST["insert"]) || isset($_POST["update"]))) :
	$sqlInsert = sprintf("INSERT INTO calendar (Title, Start)
				VALUES ('%s','%04d-%02d-%02d %02d:%02d:%02d')",
				$Title,
				$FormattedDateTime);
    $PostID = DBConnect($sqlInsert, "Insert", "dbname");
	$Message = "A new calendar entry has been created.";
endif;

 

[jpadie]

Just use a single '%s' as placeholder. The date() function already takes care of the formatting.

The way you have constructed the sprintf is to require 6 arguments for the date piece (one for each of y m d h mins and secs) but you have only supplied one (the preformatted date).

 

[PCHomepage]

I had tried that originally but it failed although it works now! Thank you.