RE: [PHP-DB] DATE(r)

use timestamp column type and populate it by $date = strtottime(date(r)); then when you want to display it $date = date('r',$row['datefieldname']); Bastien

From: "Ron Piggott" <ron.php@actsministries.org> Reply-To: "Ron Piggott" <ron.php@actsministries.org> To: "PHP DB" <php-db@lists.php.net> Subject: [PHP-DB] DATE(r) Date: Fri, 9 Sep 2005 12:52:59 -0500 Question: I am trying to for the first time create a table with a column that is defined as datetime I wanted to populate that column with the date(r) command. date(r) on my web site gives this response: Fri, 9 Sep 2005 13:32:19 -0400 How may I manipulate date(r) to give a format which is compatable to the column type 0000-00-00 00:00:00 YYYY-MM-DD 24:59:59 Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php