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
:D [/code]

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/