[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?