"2009-11-26T12:48:18.000Z" is not in "YYYY-MM-DD HH:MM:SS" format which MySQL uses. If you're sending the date as 2009-11-26T12:48:18.000Z then I'm not surprised that it's converting it to something else.
Results 1 to 9 of 9
Hybrid View
-
27 Aug 2010, 08:43 AM #1
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
Re: creating a order using zencart order functions
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
27 Aug 2010, 08:48 AM #2
New Zenner
- Join Date
- Oct 2009
- Posts
- 51
- Plugin Contributions
- 1
Re: creating a order using zencart order functions
I parse the date and send it in a mysql supported format as you suggested. it works after sending it in that way.
Originally Posted by DrByte
my concern is the time. I send the date time as 2009-11-26 12:48:18 which is from the order report. That time is a PDT one. what if a merchant hosted his store in which PDT is default?
In that case, i have to convert them to the desired timezone where the store is located. any idea on how to do it?
- Bala
-
27 Aug 2010, 08:50 AM #3
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
Re: creating a order using zencart order functions
Write something in one of the files you've got on the store's server, asking it what the time is. Calculate the difference from yours, and send the results accordingly.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
27 Aug 2010, 08:56 AM #4
New Zenner
- Join Date
- Oct 2009
- Posts
- 51
- Plugin Contributions
- 1
Re: creating a order using zencart order functions
Thank you DrByte. i will try to fix it. Originally Posted by DrByte
-
27 Aug 2010, 10:11 AM #5
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
Re: creating a order using zencart order functions
Your posts containing fixes have been moved to their own thread: http://www.zen-cart.com/forum/showth...552#post927552
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Similar Threads
-
v151 php arrays for inserting into one database field
By delia in forum General QuestionsReplies: 8Last Post: 11 Sep 2013, 03:27 PM -
v139b Database inserting into upgrade
By Philibel in forum Upgrading to 1.5.xReplies: 2Last Post: 23 Feb 2013, 10:37 PM -
Inserting a string into PHP
By bhensarl in forum Templates, Stylesheets, Page LayoutReplies: 0Last Post: 5 Nov 2010, 11:46 AM -
Occasional orders not going into the database
By colonel_t in forum Managing Customers and OrdersReplies: 21Last Post: 27 Apr 2008, 08:16 AM -
Orders not going into database -- SkipJack payment module
By usr226197 in forum Managing Customers and OrdersReplies: 2Last Post: 5 Sep 2006, 02:21 PM
