Date format in the database

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 10 months ago #342529

Hi,
I'm exporting orders directly from the database but can't decipher the data format for "order_created". It's 10 digits and looks like this: 1612791915. I guess it's a date and time but don't know how to get it right.

Please Log in or Create an account to join the conversation.

  • Posts: 81504
  • Thank you received: 13064
  • MODERATOR
1 year 9 months ago #342539

Hi,

How do you do the export ? Which version of HikaShop do you have ?
It's been years that in the order / export view file (you can edit it via the menu Display>Views), you have this line of code:

if(!empty($row->order_created)) $row->order_created = hikashop_getDate($row->order_created,'%Y-%m-%d %H:%M:%S');
which goal is precisely to convert the date in order_created into a human readable format.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum