Edward Posted April 19, 2012 Share Posted April 19, 2012 I was checking out Ebay.com and i saw the time on some items in PDT, then i checked ebay.com.sg Singapore, it shows the time in SGT. Does that mean Ebay will store the times in UTC and then convert with the SQL CONVERT_TZ function to the location of where the ebay site is located? I tried the CONVERT_TZ on my localhost but i got the NULL reading back, i guess i will leave that for later on installing the UTC times. Link to comment Share on other sites More sharing options...
Larry Posted April 20, 2012 Share Posted April 20, 2012 I would assume that's what eBay does. I don't know of a more reliable way to work with dates and times in a multi locational situation. 1 Link to comment Share on other sites More sharing options...
Edward Posted April 20, 2012 Author Share Posted April 20, 2012 I first thought that the ebay time system would be rather complicated but this helps simplify the matter, thanks Larry. Link to comment Share on other sites More sharing options...
Larry Posted April 20, 2012 Share Posted April 20, 2012 I have a specific example of how to do this in my PHP & MySQL book. Link to comment Share on other sites More sharing options...
Edward Posted April 20, 2012 Author Share Posted April 20, 2012 Yes i know i did read it, just wanted to hear the words from you about Ebay, i just helped one of your readers out now on the same topic just a minute ago. This is the second time now i was just about to sleep and i saw one question on the ipad i could answer so i jumped out of bed ran down stairs and switched on the PC, well that's me for today. Goodnight Larry and Everyone. Link to comment Share on other sites More sharing options...
Recommended Posts