Code

Create a MySQL TIMESTAMP from a Unix Timestamp

This simple function formats a Unix Timestamp as one ready to be inserted into MySQL.

function mktimestamp($epoch) {
	$epoch = date("Y-d-m H:i:s", $epoch);
	
	return $epoch;
}

Posted at 11:17 on 2 st July 2009

This blog is here to throw code snippets, either what I regularly reuse, or that interest me at the time of making them. You won't find any big writings here. If you are interested in the motivations behind this and how it was made, please read this article.

You may use any of this source code as you wish, without attribution (although, it'd be nice.) I do however reserve no responsibility for it's quality or it's correctness. If you spot a problem, tell me and I will fix it.

Subscribe to the RSS Feed

Problem? Tell me.

Code a selection of code snippets published by Nick Charlton

Create a MySQL TIMESTAMP from a Unix Timestamp