How to show time in dates?

[hubert]

Hello,

Long time ago I made a custom functions_email.php. This is great but now I need to show the time in the orders date.

I found the place where it is, in my line 516 I find :
zen_date_long($order_check->fields['date_purchased'])

the result in the mail is "Thursday 25 August, 2011"

I'd like it to be "Thursday 25 August, 2011, 15:16:17"

If I go to see date_purchased in phpMyAfmin I see that the time is here in the date_purchased field but I don't know how to get it.

What do I need to modify to get this in this file and only in this file ?
Do I need to replace zen_date_long by another function ? If so which one ?
Do I need to build a custom function so that the time is shown only in this case (if so I really need help) ?


Thanks for reading and your help.

Regards

Hubert

[Ajeh]

Customize the format on the define:

/admin/includes/languages/english.php

Line #22 : define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime()

to suite your specific needs ...

[hubert]

Thanks for the answer,

I've changed
define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime()

with

define('DATE_FORMAT_LONG', '%A %d %B, %Y H:i:s'); // this is used for strftime()

and that doesn't do the trick.

The output is still : Saturday 27 August, 2011

Hubert

[Ajeh]

Try this:

/admin/includes/languages/english.php

Line #25 : define('DATE_FORMAT_LONG', '%A %d %B, %Y %H:%M:%S'); // this is used for strftime()

[hubert]

Hmmm... That's still not the solution.

To be complete here is my mod in fuction_email.php

$order_check = $db->Execute("select orders_id, cc_cvv, customers_name, customers_company, customers_street_address,
                                    customers_suburb, customers_city, customers_postcode,
                                    customers_state, customers_country, customers_telephone,
                                    customers_email_address, customers_address_format_id, delivery_name,
                                    delivery_company, delivery_street_address, delivery_suburb,
                                    delivery_city, delivery_postcode, delivery_state, delivery_country,
                                    delivery_address_format_id, billing_name, billing_company,
                                    billing_street_address, billing_suburb, billing_city, billing_postcode,
                                    billing_state, billing_country, billing_address_format_id,
                                    payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
                                    currency_value, date_purchased, orders_status, last_modified, shipping_method
                             from " . TABLE_ORDERS . "
                             where orders_id = '" . (int)$MyoID . "'");
.
.
.
 $Emb_Order_Extra = '<table border="0" cellspacing="0" cellpadding="2"  width="275"><tr><td class="main"><strong>' .  ENTRY_DATE_PURCHASED .  '</strong></td></tr><tr><td class="main">' .  zen_date_long($order_check->fields['date_purchased']) .  '</td></tr><tr><td class="main">' .  '<b>Customer comments: </b><br>' . $orders_history->fields['comments'] .  '</td></tr><tr><td class="main"><b>' .  ENTRY_PAYMENT_METHOD .  '</b></td></tr><tr><td class="main">' .  $order->info['payment_method'] .  '</td></tr></table>';

As far as I see the function is "zen_date_long($order_check->fields['date_purchased'])"

I don't understand why the modifications doesn't modify anything, it's as if it wasn't the good english.php file.... ???

I'm puzzled..

Thanks again for your help

Hubert

[Ajeh]

Not sure what to tell you about your custom code in the function ...

I know that change in the admin english.php will make the orders display with both date and time that you can see when you edit the order ...

Date Purchased: Monday 29 August, 2011 23:15:07
Payment Method: Check/Money Order

You will need to see if you are not modifying the function file correctly ...

[Ajeh]

NOTE: if your function is for the Catalog, you need to also edit the Catalog english.php file ...
/includes/languages/english.php

[hubert]

As far as I only want to modify the format for my mod and nowhere else, can I write something like that in my custom functions_email.php ?

define('DATE_FORMAT_LONG', '%A %d %B, %Y %T');
 $Emb_Order_Extra = '<table border="0" cellspacing="0" cellpadding="2"  width="275"><tr><td class="main"><strong>' .  ENTRY_DATE_PURCHASED .  '</strong></td></tr><tr><td class="main">' .  zen_date_long($order_check->fields['date_purchased']) .  '</td></tr><tr><td class="main">' .  '<b>Customer comments: </b><br>' . $orders_history->fields['comments'] .  '</td></tr><tr><td class="main"><b>' .  ENTRY_PAYMENT_METHOD .  '</b></td></tr><tr><td class="main">' .  $order->info['payment_method'] .  '</td></tr></table>';
define('DATE_FORMAT_LONG', '%A %d %B, %Y');

i.e. changing the format temporarly and then redefining it as it was before.

Hubert