[Godwin]

Hi,

Ok this may have a simple solution but I couldn't get it work right.

I have 2 columns in the schedule table (hours,mins), which stores the values entered from a form. This would represent the time in singapore format.

My problem is that I want to first convert the singaporean time(GMT +8) to my local time(sri lanka GMT +5.5). For that I need to convert it to GMT first then using offsets I can calculate my local time. So I substract 28800 seconds from the singapore time and now I have the GMT time I can simply convert that to my time zone. But how do I first get the values from hours and mins columns and store it in a variable in time format?


This code below is based on my local time and calculates correctly both in gmt and singapore time.

PHP Code:

$srilanka_time = time();

$gmt = $srilanka_time - (19800);



$singapore_time = $gmt + (28800);

echo 'GMT is: '.date('H:i', $gmt); 

echo 'Singapore time is: '.date('H:i', $singapore_time); 

This code below is what I have done to get the GMT time based on singapore time.

PHP Code:

$singapore_time =  //should get values from $row_Recordset1['hours'] and

//$row_Recordset1['mins']



$gmt = $singapore_time - (28800);



echo 'GMT is: '.date('H:i', $gmt); 

As you can see I want to get the correct time format which will be stored in $singapore_time variable given the following values:
$row_Recordset1['hours']
$row_Recordset1['mins']

Can anyone please help me with this ?

[UnrealEd]

to get the GMT date, you just have to use gmdate, this automaticly converts the local time to gmt.

to convert it back to singapore time, use the mktime() function: you enter the hours, minutes and seconds and it will create a new time. for you this could look like this:

PHP Code:

$gmt = gmdate("H:i");

$singapore_time = date("H:i", mktime(gmdate("H")+5, gmdate("i")+30, gmdate("s"), gmdate("m"), gmdate("d"), gmdate("Y"))); 

maybe there's a simpeler sollution, but this is one i just found, while looking on www.php.net,
UnrealEd

[Godwin]

Hey UnrealEd, thanks for you code.
That worked!

I had to modify a bit so that it takes the values hours and mins from the table. I managed to get it working by refering the links you gave.
I used:
mktime($row_Recordset1['hours'],$row_Recordset1['mins']);

Cool man
thanks!