Irresistable Posted November 3, 2009 Share Posted November 3, 2009 The time of php.. is set 6 hours behind GMT time. How can I change this. So that when people subscribe to the news letter, it shows the GMT time, instead of GMT-6 Thanks Quote Link to comment https://forums.phpfreaks.com/topic/180137-how-do-i-change-the-time-of-phpmyadmin-in-my-database-tables/ Share on other sites More sharing options...
JonnoTheDev Posted November 3, 2009 Share Posted November 3, 2009 Is it a linux box? Change the server timezone: http://www.wikihow.com/Change-the-Timezone-in-Linux Quote Link to comment https://forums.phpfreaks.com/topic/180137-how-do-i-change-the-time-of-phpmyadmin-in-my-database-tables/#findComment-950285 Share on other sites More sharing options...
Irresistable Posted November 3, 2009 Author Share Posted November 3, 2009 I don't know what Linux is... How would I find out if my phpMyAdmin is .. linux etc.. It's on a paid webhosting. Quote Link to comment https://forums.phpfreaks.com/topic/180137-how-do-i-change-the-time-of-phpmyadmin-in-my-database-tables/#findComment-950289 Share on other sites More sharing options...
JonnoTheDev Posted November 3, 2009 Share Posted November 3, 2009 It's on a paid webhosting Then you will not have access to the server. You will have to set the timezone in the code. phpMyadmin is a database admin utility, nothing to do with the server. <?php date_default_timezone_set('Europe/London'); // should print current date / time print date('d-m-Y H:i:s'); ?> http://php.net/manual/en/function.date-default-timezone-set.php Quote Link to comment https://forums.phpfreaks.com/topic/180137-how-do-i-change-the-time-of-phpmyadmin-in-my-database-tables/#findComment-950322 Share on other sites More sharing options...
Irresistable Posted November 3, 2009 Author Share Posted November 3, 2009 Where do I put that piece of code? Quote Link to comment https://forums.phpfreaks.com/topic/180137-how-do-i-change-the-time-of-phpmyadmin-in-my-database-tables/#findComment-950331 Share on other sites More sharing options...
JonnoTheDev Posted November 3, 2009 Share Posted November 3, 2009 Where are you displaying the time? You are not making yourself very clear. Quote Link to comment https://forums.phpfreaks.com/topic/180137-how-do-i-change-the-time-of-phpmyadmin-in-my-database-tables/#findComment-950341 Share on other sites More sharing options...
Irresistable Posted November 3, 2009 Author Share Posted November 3, 2009 I have a mySQL database.. which is used on phpMyAdmin on my cPanel. I have a newsletter. The user signs up to it.. and details get entered in the database. I want to display the time in there. I have got it to display the time, but not GMT london time. Quote Link to comment https://forums.phpfreaks.com/topic/180137-how-do-i-change-the-time-of-phpmyadmin-in-my-database-tables/#findComment-950384 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.