Convert Twitter API Datetime to MySQL Datetime Format

Revision: 52223

at October 17, 2011 00:51 by aristoworks

Initial Code

function convert($twitter_datetime = '') {

	$mysql_format = date("Y-m-d H:i:s", strtotime($twitter_datetime));

	return $mysql_format;

}

// SIMPLE USAGE

$date = convert("Sat, 15 Oct 2011 00:29:53 +0000");

// WILL RETURN 2011-10-14 00:29:53

Initial URL

http://www.aristoworks.com

Initial Description

This is a very rudimentary function used to convert a Datetime delivered by the Twitter API to a format you can store in MySQL's datetime field.

Initial Title

Convert Twitter API Datetime to MySQL Datetime Format

Initial Tags

mysql, php, date, api, convert, twitter

Initial Language

PHP

Choose a language for easy browsing: