is this possible? (php)

adam_uk · 11-23-2004, 02: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

thanks
adam

cerebus · 11-24-2004, 03: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, 03:30 AM

you genius!! thanks!

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

My pleasure. Thank you for the NP donation.

11-24-2004, 03:19 AM	#2 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395 655.10 NP$ (Donate)	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, 03:30 AM	#3 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	you genius!! thanks!

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

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