[Skip to main content](#vessel-content)

#   Date format for hikashop\_order order\_created

##

- **[fireballxl5](/forum/user/7893-fireballxl5 "View fireballxl5's Profile")**
- [![fireballxl5's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7893-fireballxl5 "View fireballxl5's Profile") Topic Author
- [ Offline](/forum/user/7893-fireballxl5)

Less More

- Posts: 38
- Thank you received: 0
-
-
-
- [](https://mediastreamz.com)
-

12 years 8 months ago [\#147457](#147457) by [fireballxl5](/forum/user/7893-fireballxl5 "View fireballxl5's Profile")  *[Date format for hikashop\_order order\_created](/forum/30-integrations/866474-date-format-for-hikashop-order-order-created#147457 "Hi all I am trying to pull data via an ODBC connector from Hikashop into MS Access so that I can integrate it with other systems. When I look at order_created in hikashop_order I am seeing values like 1343065635 and 1380810301 which I don't recognise. I need to convert them to a standard dd-mm-yyyy format can you tell me how I can convert the string?  Thanks")* was created by *[fireballxl5](/forum/user/7893-fireballxl5 "View fireballxl5's Profile")*

Hi all
I am trying to pull data via an ODBC connector from Hikashop into MS Access so that I can integrate it with other systems. When I look at order_created in hikashop_order I am seeing values like 1343065635 and 1380810301 which I don't recognise. I need to convert them to a standard dd-mm-yyyy format can you tell me how I can convert the string?

Thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84NjY0NzQtZGF0ZS1mb3JtYXQtZm9yLWhpa2FzaG9wLW9yZGVyLW9yZGVyLWNyZWF0ZWQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4079
-
- [](http://obsi.dev)
-

12 years 8 months ago [\#147459](#147459) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Date format for hikashop\_order order\_created](/forum/30-integrations/866474-date-format-for-hikashop-order-order-created#147459 "Hi all I am trying to pull data via an ODBC connector from Hikashop into MS Access so that I can integrate it with other systems. When I look at order_created in hikashop_order I am seeing values like 1343065635 and 1380810301 which I don't recognise. I need to convert them to a standard dd-mm-yyyy format can you tell me how I can convert the string?  Thanks")*

Hi,

In HikaShop, the dates are stored in unix timestamp format.
You can use the function hikashop_getDate() for the conversion into string.

Regards,

---

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [fireballxl5](/forum/user/7893-fireballxl5 "View fireballxl5's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84NjY0NzQtZGF0ZS1mb3JtYXQtZm9yLWhpa2FzaG9wLW9yZGVyLW9yZGVyLWNyZWF0ZWQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.040 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)