Re: [PHP-DB] Function to convert a Date String to a MYSQL TimeStamp
You can use
date('YmdHis',strtotime($your_date_string));
check
http://ro.php.net/manual/en/function.date.php
for more about the date function.
On Sat, 2005-05-07 at 18:06 -0700, Graham Anderson wrote:
I need to batch convert a bunch of date strings into mysql time stamps:
If I have the following:
May 7, 2005, 7:29 pm
how do I convert that to a MySQL Timestamp like:
20050507192957
many thanks
g
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Function to convert a Date String to a MYSQL TimeStamp
strtotime bastien From: Graham Anderson [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Function to convert a Date String to a MYSQL TimeStamp Date: Sat, 7 May 2005 18:06:12 -0700 I need to batch convert a bunch of date strings into mysql time stamps: If I have the following: May 7, 2005, 7:29 pm how do I convert that to a MySQL Timestamp like: 20050507192957 many thanks g -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
