Welcome Guest, Not a member yet? Register   Sign In
Date and time help!
#4

[eluser]dmorin[/eluser]
Quote:I still didn’t get it, when do I use those function and where, or could you give me an example on how to use it in my app?
It's going to be tough to give you an example, when you're question was so generic. You haven't told us at all what you're doing.

Quote:I thought if I move from server to server, the time zone changes then I will get the wrong time unless I update.
That's why for all of the servers I use, I set the timezone to UTC both in PHP and in MySQL. That way, I'm always storing them consistently. If you're worried about changing DB servers and that giving you bad times because of the way MySQL stores dates and times, then just store unix time stamps as integers instead since these are always in UTC and it's easy to convert them to and from any format or timezone.

If you need any specific suggestions, please thoroughly explain what you're doing first and then we'll see what we can come up with.


Messages In This Thread
Date and time help! - by El Forum - 02-23-2010, 11:04 AM
Date and time help! - by El Forum - 02-23-2010, 06:07 PM
Date and time help! - by El Forum - 02-24-2010, 02:09 AM
Date and time help! - by El Forum - 02-24-2010, 07:53 AM
Date and time help! - by El Forum - 02-24-2010, 11:30 AM
Date and time help! - by El Forum - 02-24-2010, 11:38 AM
Date and time help! - by El Forum - 02-24-2010, 11:45 AM
Date and time help! - by El Forum - 02-24-2010, 11:55 AM
Date and time help! - by El Forum - 02-24-2010, 12:14 PM



Theme © iAndrew 2016 - Forum software by © MyBB