Hi all
can somebody point me in right direction, or even tell me for class or function (that works ok) that can convert date and time from one timezone to another with daylight saving
thank you
kind regards
convert timezone
Moderator: General Moderators
- JAB Creations
- DevNet Resident
- Posts: 2341
- Joined: Thu Jan 13, 2005 6:44 pm
- Location: Sarasota Florida
- Contact:
Re: convert timezone
I think this will work for you...change the time zone for your time zone of course which should be like +4:00 or something? I'm not sure off hand.
Code: Select all
$db = mysql_connect("localhost", $truedbuser, $truedbpass);
mysql_query("SET time_zone = '-4:00';");Re: convert timezone
thank you for reply
Re: convert timezone
don't think that works. it simply sets the timezone of the MySQL session connection, meaning any MySQL fns that are timezone aware will respond offset by 4.
not the same as converting and does not have DST applied.
check http://mysql.oss.eznetsols.org/doc/refm ... pport.html
and viewtopic.php?f=19&t=92892&st=0&sk=t&sd=a
not the same as converting and does not have DST applied.
check http://mysql.oss.eznetsols.org/doc/refm ... pport.html
and viewtopic.php?f=19&t=92892&st=0&sk=t&sd=a
Re: convert timezone
thank you for reply.
it doesn't have nothing to do with mysql
I've build my own class for converting time
kind regards
it doesn't have nothing to do with mysql
I've build my own class for converting time
kind regards