How to interpret the date fields in database?

  • Posts: 62
  • Thank you received: 0
12 years 11 months ago #31961

How do you interpret the integer value in the order_created field that is in the jos_hikashop_order table?

We are using this value in an ODBC connection and can't figure out how to interpret this field as a valid date.

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
12 years 11 months ago #31972

That's a unix timestamp: en.wikipedia.org/wiki/Unix_time

You can easily convert it to a date using the date() function of PHP: php.net/manual/en/function.date.php
or the hikashop_getDate() function which handles automatically the timezones based on your joomla settings.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum