How do I change the time of phpmyadmin in my database tables

[Irresistable]

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

[JonnoTheDev]

Is it a linux box?

Change the server timezone: http://www.wikihow.com/Change-the-Timezone-in-Linux

[Irresistable]

I don't know what Linux is... How would I find out if my phpMyAdmin is .. linux etc.. It's on a paid webhosting.

[JonnoTheDev]

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

[Irresistable]

Where do I put that piece of code?

[JonnoTheDev]

Where are you displaying the time?

You are not making yourself very clear.

[Irresistable]

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.