> I am on the East Coast of Australia.

I'm in central Queensland...

 > Do you know if by default if the date/time display will 
 > display only East coast Australia time, or will display  
 > from the user's time zone? eg Will USA users see the 
 > Australian time or their own time? Would this cause a issue 
 > with timestamping an order when it comes to writing to a 
 > mySQL database?

I presume we're talking about php date/time stuff here?  In that case,
php gets it's date/time from the server it is running on.  If your
server is on the east coast of Australia then you'll have local time for
east coast of Aust.

One way to deal with this would be to take everything back to GMT/UTC/Z
and use that instead.  Then all you need to do is add an appropriate
adjustment to get local time where ever the browser is - of course, you
may not easily be able to figure that out so it's not necessarily a
perfect solution.

In the end, the solution will depend on your requirements.  What are you
using a timestamp for?  If it's purely as a reference point in database
queries (i.e. all changes in the past two days, or 10 mins) then it
probably doesn't matter all that much.  Your database will be updated
from your server and your server has a consistent internal time.

If your application is date dependant in an absolute way then it becomes
a little harder I guess.  Although, you'd also ask yourself how relevant
it becomes to someone in a vastly different time zone - i.e. if you're
doing a local event calendar (which just happens to be one of the things
I'm doing right now) then the fact that an event might be happening
right now instead of this time tomorrow (from the perspective of someone
on the other side of the world and their time zone) is largely
immaterial - they aren't going to get there anyway.

Perhaps the simplest approach to that is to include a time/date
reference.  If you're going to include date information let the browser
know the context.  So, you advertise the next 'xxx' event will be at 3PM
17 May and tell them that it's 10:30AM on 17 May right now.  Leave any
relevant math up to them.

 > Can someone suggest a script that may give me the option to 
 > offer both  time zones to the user?

You could probably do something in javascript (being client-side it
knows the time in the browsers' location) to work out equivalencies and
conversions if you like.

CYA, Dave

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to