Hello,
I want to display content from a custom table in imported from another database. The query works fine but I want to format a datetime value and only include year, month, day.
My query looks something like -
$result = db_query('SELECT name, date, summary from table.test
where posting_status=\'A\'',array());
foreach ($result as $record) {
print '<b>Name:</b> '.$record->name;
print '<b>Date :</b> '.$record->date;
print '<b>Summary:</b> '.$record->summary;
}
