Date format in the database

Andor
Topic Author
Offline

4 years 3 months ago #342529 by Andor

Date format in the database was created by Andor

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.

nicolas
Offline

4 years 3 months ago #342539 by nicolas

Replied by nicolas on topic Date format in the database

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:

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.225 seconds