Re: [PHP-DB] DATE(r)

2005-09-09 Thread Jordan Miller
You need to use: date('Y-m-d H:i:s'); It's in the comments at: http://www.php.net/date Jordan On Sep 9, 2005, at 12:52 PM, Ron Piggott wrote: 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 dat

RE: [PHP-DB] DATE(r)

2005-09-09 Thread Bastien Koert
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" <[EMAIL PROTECTED]> Reply-To: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Subject: [PHP-DB] DATE(r) Date: Fri,