FreeHostia Forums https://forum.freehostia.com/ |
|
change timezone mysql https://forum.freehostia.com/viewtopic.php?f=7&t=12278 |
Page 1 of 1 |
Author: | nikbha1 [ Sun Dec 20, 2009 11:56 pm ] |
Post subject: | change timezone mysql |
My mysql table strucyure is Code: CREATE TABLE `testimonials` ( `testimonial_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(45) NOT NULL, `address` varchar(45) NOT NULL, `contact_no` varchar(20) NOT NULL, `testimonial` text NOT NULL, `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` varchar(45) NOT NULL DEFAULT 'awaiting approval', `read_status` varchar(6) NOT NULL DEFAULT 'unread', PRIMARY KEY (`testimonial_id`) ) ENGINE=MyISAM all i want is to change my time zone to GMT +05:30 so that the code below saves a timezone specific to my country Code: `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, couldn't find any entry for timezone in phpmyadmin to change timezone. I am ready to change the table structure to Code: `datetime` timestamp NOT NULL, if anyone can suggest a php code for setting timezone thanks in advance ![]() |
Author: | widwool [ Mon Dec 21, 2009 8:57 pm ] |
Post subject: | |
Hello, Please note that we offer a shared hosting service, therefore you are not able to change the time zone of the server only in your hosting account. If you have any additional questions, please let us know |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |