Making the Dates Easier to Read

[jonesevan007]

Hey guys,

 

Been editing the admin order module (admin/includes/modules/index/orders.php) and have really had fun changing stuff around.

 

I successfully changed this:

Old osc orders style (sorted by date last modified)

Customer Name | Total | Date Last Modified | Status

 

to this:

New style (sorted by order#)

Customer Name | # | Total | Date Purchased | Status

 

but now I request help changing the date_purchased format from 2008-12-31 06:22:35 to 12/31/08 6:22am on the admin homepage (which draws from the orders module)

 

is there a way to massage the database output to format a date differently?

 

might it have something to do with date()? thanks for the counsel!

 

----------------------------------------------------------------------------------------------------

for those interested in the changes I've made to the sorting of orders, here's the source of my admin/includes/modules/index/orders.php

<table border="0" width="100%" cellspacing="0" cellpadding="4">
 <tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent">Order</td>
<td class="dataTableHeadingContent">   #</td>
<td class="dataTableHeadingContent">  Total</td>
<td class="dataTableHeadingContent">Date Purchased</td>
<td class="dataTableHeadingContent">Status</td>
 </tr>
<?php
 $orders_query = tep_db_query("select o.orders_id, o.customers_name, o.date_purchased, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id desc limit 30");
 while ($orders = tep_db_fetch_array($orders_query)) {
echo '  <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">' .
	 '	<td class="dataTableContent"><a href="' . tep_href_link(FILENAME_ORDERS, 'oID=' . (int)$orders['orders_id'] . '&action=edit') . '">' . tep_output_string_protected($orders['customers_name']) . '</td>' .
	 '	<td class="dataTableContent">' . $orders['orders_id'] . '</td>' .
	 '	<td class="dataTableContent">' . strip_tags($orders['order_total']) . '</td>' .
	 '	<td class="dataTableContent">' . $orders['date_purchased'] . '</td>' .
	 '	<td class="dataTableContent">' . $orders['orders_status_name'] . '</td>' .
	 '  </tr>';
 }
?>
</table>

[germ]

For this line:

 

		 '	<td class="dataTableContent">' . $orders['date_purchased'] . '</td>' .

Try:

 

		 '	<td class="dataTableContent">' . strftime( "%m/%d/%y %I:%M%P" , strtotime($orders['date_purchased'] ) ) . '</td>' .

BACKUP FIRST!

[jonesevan007]

Thanks Jim!

 

Works perfectly

[♥geoffreywalton]

For another place you can change the date format go to /includes/languages/english.php

 

Then you can use the functions to format dates.

 

Enjoy