Welcome Guest, Not a member yet? Register   Sign In
I'm on the east coast, my database (mysql) server is on the west. How do we resolve our differences?
#10

[eluser]tmcw[/eluser]
Quote:You’re not inserting MySQL’s NOW() into the database. You are inserting the returned data from Code Igniter’s now() function within the Date helper.

actually, I have been using MySQL's NOW(). CI's would return a unix timestamp.



Quote:What do you mean a global timezone?
I would wrap those into a class, and use methods to convert the time.
What’s good about gmt_to_local is it gets the local timezone and converts the gmt time to that. Why would you need a global timezone? And if you did it should be GMT to conform to the standard (unless your website is generally only for one specific country)
Hope this helps,

Global as in application-wide. My server and database are in PDT, for whatever reason. I'll be storing datetime fields in GMT. I need to retrieve them as Eastern time. See the problem?


Messages In This Thread
I'm on the east coast, my database (mysql) server is on the west. How do we resolve our differences? - by El Forum - 08-21-2007, 11:22 AM



Theme © iAndrew 2016 - Forum software by © MyBB