It is currently Thu Mar 28, 2024 11:20 am


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: change timezone mysql
PostPosted: Sun Dec 20, 2009 11:56 pm 
Newbie
Newbie

Joined: Sun Dec 20, 2009 11:39 pm
Posts: 1
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]


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 21, 2009 8:57 pm 
Site Admin

Joined: Fri Aug 22, 2008 10:59 am
Posts: 256
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

_________________
Best Regards,
WidWool


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ]  Moderators: Moderators, Support Team

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Hosting | Domains | Servers | Extras | Order | Support | Contacts | FreeHostia © 2011