Order Date in number to export data shopping

  • Posts: 345
  • Thank you received: 10
  • Hikashop Business
9 years 2 months ago #241271

-- url of the page with the problem -- : www.hermanosgaliano.es
-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.5.1
-- Browser(s) name and version -- : Chrome

Hello good day.
I would like to get an inquiry .
I'm using phpMyAdmin and Fabrik component to query statistics of my website.
It turns out that the date field orders throws me a number I am unable to translate it to date. I tried it with Excel and no way .
For example , an order dated 05/24/2016 19:32 throws me the number 1464111174 .
Do you know how I can fix it?

Thank you very much.
Regards.

Attachments:

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

  • Posts: 84233
  • Thank you received: 13675
  • MODERATOR
9 years 2 months ago #241286

Hi,

That's normal. It's a unix timestamp.
You need to use the FROM_UNIXTIME() function of MySQL in your query in order to convert it into a readable date:
dev.mysql.com/doc/refman/5.7/en/date-and...nction_from-unixtime

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

Time to create page: 0.085 seconds
Powered by Kunena Forum