is this possible? (php)

adam_uk · 11-23-2004, 03:07 PM

hey
quick question
i have a date for example like this

Quote:

Thursday 25th of March 2004 11:19:05 AM

generated with php date function is there anyway to convert this into a timestamp?

dont really wanna edit 400 rows in a mysql db lol
ie 3676567354
????: NamePros.com http://www.namepros.com/programming/56787-is-this-possible-php.html

thanks
adam

cerebus · 11-24-2004, 04:19 AM

A little regex is needed to make strtotime recognize the date. The below should work:

PHP Code:

  <?

$string="Thursday 23rd of March 2004 11:19:05 PM";

$timestamp=strtotime(preg_replace("#([0-9]+)(th|rd|st) of #","$1 ",$string));

?>

adam_uk · 11-24-2004, 04:30 AM

you genius!! thanks!

cerebus · 11-24-2004, 11:36 AM

My pleasure. Thank you for the NP donation.

11-24-2004, 04:19 AM	#2 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395	A little regex is needed to make strtotime recognize the date. The below should work: PHP Code: `<? $string="Thursday 23rd of March 2004 11:19:05 PM"; $timestamp=strtotime(preg_replace("#([0-9]+)(th\|rd\|st) of #","$1 ",$string)); ?>`

11-24-2004, 04:30 AM	THREAD STARTER #3 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	you genius!! thanks!

11-24-2004, 11:36 AM	#4 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395	My pleasure. Thank you for the NP donation.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)