Order date is not stored in 24 hour format in the database

For some reason the Order Date timestamp to the database is being stored in 12 hour format.

Is this done on the confirm page?

The time wraps back to 1 after 12:59 which makes it looks as if all orders are being placed in the AM except between 12:00 and 12:59.

I am using a Mysql data base, and tried timestamp and datestamp with the same results.

yes, the order information is stored into the database on the confirm page.

on the confirm page, open the server behaviors panel, then double click on the eCart Store order Summary behavior, what is the code there for the order data column?

It is set to the following

Order Date <?php echo (date('Y-m-d h:i:s')); ?>

With the type set to date.

see the php date manual page:
function.date.php




either use a capitol H to return the hour in 24 hour format, add a lower case "a" to output Lowercase am / pm at the end, or add an upper case "A" for upper case AM / PM

<?php echo (date('Y-m-d h:i:s a')); ?>
would output: 2011-07-13 05:29:48 pm

<?php echo (date('Y-m-d h:i:s A')); ?>
would output: 2011-07-13 05:29:48 PM

<?php echo (date('Y-m-d H:i:s')); ?>
would output: 2011-07-13 17:29:48

Thank you!

I got all my other order dates to display in the proper format but it assumed that the database value was in the standard mysql format.

This fixed every thing for me.

Thanks again.

you're welcome.