PHP - Date Time Zone

I am trying to get local date/time.
In my php file I am setting my timezone using
$timezone = "America/Toronto";
putenv ('TZ=' . $timezone);
Then I use the following to get current date and time
print_r (getdate());
but my date displays in GMT,
What am I doing wrong? As in the code above I am in Toronto and I need EST.

I am sorry I have absolutely no idea where this question fits in this forum bcoz its related to PHP , MySQL and Javascript... 

So here is my question ..

I use MySql database to store posts.. where 'postdate and time' is saved using  'CURRENT_TIMESTAMP' of MySql that offcourse gives "2010-08-31 09:47:10" format...

When I have to calculate when the post was posted just before loading the posts on users wall e.g.

"2 min ago"...

I take the 'postdate and time' from database then use strtotime() function in php to convert it to string you know since jan 1 1970.

Now this time stamp is sent to javascript function which uses 'Date' Object to create current time and then 'getTime' to get the string like one Mentioned earlier. it then calculates the difference and displays it..

Just to inform you.. I used javascript to I may refresh "posted since" periodically using "SetInterval()"

But the problem here arises. There is difference of 1 Hour and 24 Sec in both times.......

  Sorry If I confused you... But the problem is simple. In javascript date object and MySql  --> strtotime()
there is time difference...

How I can correct it ???


please Help ...

Codes:

1. function to convert str to time


function change($date){

$time_early=strtotime($date);

return $time_early;


}



 

2. javascript Code to check "Post Since"



function calc_difference() {

$("[name=posttime]").each(function() {

 var current=$(this).attr("id");
  localtimevalue = new Date();
d = localtimevalue.getTime();

         
 
 var d= parseInt(d)/1000;
 var diff=d-parseInt(current);  

 var diff=parseInt(diff);
 var min=parseInt(diff/60);         
 var hours=parseInt(diff/3600);
var days=parseInt(diff/86400);
var months=parseInt(diff/2592000);
var years=parseInt(diff/31104000);


if( min==0 ){ 


$(this).text("Posted: "+diff +" seconds ago ");

}



if(min>0 && hours==0 && days==0 && months==0){ 
if(min==1){
 $(this).text("Posted:  a minute ago ");
        
}else{
 
$(this).text("Posted: "+min +" minutes ago ");
}

}

if(min>0 && hours>0 && days==0 && months==0){ 

if(hours==1){
 $(this).text("Posted:  an hour ago ");
        
}else{
 
$(this).text("Posted: "+hours +" hours ago ");
}



}

if(days>0 && months==0 && years==0){ 


if(days==1){
 $(this).text("Posted:  a day ago ");
        
}else{
 
$(this).text("Posted: "+days +" days ago ");
}



}



if(months>0 && years==0 ){ 


if(months==1){
 $(this).text("Posted:  a month ago ");
        
}else{
 
$(this).text("Posted: "+months +" months ago ");
}



}


if(years>0){ 


if(years==1){
 $(this).text("Posted:  a year ago ");
        
}else{
 
$(this).text("Posted: "+years +" years ago ");
}



}








  });


   
}






 
Javascript function is called on load and Jquery's .each function is used to update all post's time.


 

I have all the dates stored in my database as UTC and I want to retrieves these UTC date/time to show the local time zone. So, example, If I live in New York, I want it to show east coast time zone and not the Universal Time. Any idea?

Purpose: To get time zone of a remote file in my time zone. I have to download a file daily (mp3, don't worry its legal!) from BBC. Problem is that sometimes BBC doesn't update the file and i have to download entire file to check if it has been updated or not. Hence i decided to code a page that gives me date and time of that remote file. I have successfully compiled the code (that i got from internet). But the time returns in EST. I want the time in IST (indian std time Asia/Calcutta). CURLINFO_FILETIME has bee used. Below is code.

Pls suggest me how to convert EST to IST - Warning: I am a newbie. But i can follow instructions

Code: [Select]
<?php
$curl = curl_init('http://wsdownload.bbc.co.uk/hindi/tx/32mp3/din_bhar.mp3');

//don't fetch the actual page, you only want headers
curl_setopt($curl, CURLOPT_NOBODY, true);

//stop it from outputting stuff to stdout
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);

// attempt to retrieve the modification date
curl_setopt($curl, CURLOPT_FILETIME, true);

$result = curl_exec($curl);

if ($result === false) {
    die (curl_error($curl)); 
}

$timestamp = curl_getinfo($curl, CURLINFO_FILETIME);
if ($timestamp != -1) { //otherwise unknown
    echo "BBC Hindi was last modified" . date("d-m-Y h:i:s A T", $timestamp); //etc
} ?>


I have used it with custom getRemoteFileSize function he -
Code: [Select]
http://island.web44.net/bbc.php

Hello Everyone,

I am on windows server and In my ini file server time zone declared as below

[server_settings]
date.timezone = "Europe/London"

but my application installed on another timezone eg: 'America/Los_Angeles' time zone.

using date_default_timezone_get() i am always getting Europe/London timezone as it's declared in ini file. How to get local timezone(wherever application is installed) here?

Thanks Krish

Hey guys,
How would I go about subtracting Today from a previous day to find the difference?

For example, I want to subtract TODAY from a previous date in my database, to determine if the difference is greater than 1 day.

Any ideas? I tried doing the subraction in TIMESTAMPS, but when I convert the date back to Y-m-d H:i:s, I got some weird year and time.
 

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel

I am having a problem with PHP displaying the correct date and time. It updates as it should, but is fast by 4min and is always displaying a date in 2004. I ran a basic php script to make sure the application im using itself is not wrong. go to lunenburgledger.com/time.php

Anybody had any ideas on where to check? The system time on the Windows Server 2003 is correct. The only thing I can think of is that it was converted to a virtual machine on vmware esxi, but the system time stayed right. Any ideas?

Thanks!

OK So I've got a datepicker that sends a date in d/m/y format. My DB stores the data in Unix Timestamp Which I can convert the date to with strtotime however this does the exact date & time.

All I want is the actual day. I've spent hours trying to convert this with just the day with mixed results...

Thanks.

Hey,

I need help with my date & time string.
I need to edit it do show in a string + also use it for calculating things like when the date has passed.

The string is like this:
Code: [Select]
<?php $string = '2011-01-01 00:00 AM'; ?>

So i wanted to check if there was a function that can automatically convert it, so it would say for example:


Quote

Sunday, 1st of January 2011
00:00 AM



But at the same time compare $string against server time to see if the date has expired?

Hope you can help

I have a batch script that reads from a timestamp.txt file to determine the last time it ran and I need to modify that by two hours.
What happens is the script will run to look for changes in the county records and their server time is two hours different from mine.

Code: [Select]
$fr=fopen("xml/timestamp.txt",'r');
$mydate=fread($fr, 50);
if ($incremental_updates == 1){
$default_template_file="xml/incremental_template.xml";
$default_config_name="xml/incremental.xml";
$contest=file_get_contents($default_template_file);
$contest=str_replace("{DATE_TAG}", $mydate, $contest);
$f=fopen($default_config_name,'w+');
fwrite($f, $contest);
fclose($f);
fclose($fr);
$fw=fopen("xml/timestamp.txt",'w');
fwrite($fw, substr(date('c'), 0, 19));
fclose($fw);
}else{
$default_config_name = "xml/full_update.xml";
}

I tried making a time stamp update look like $cur_timestamp=date("Y-m-d H:i:s", time() +14400); which is correct but it doesn't write to the text file properly.

Using the above fwrite($fw, substr(date('c'), 0, 19));
I get the correct results in the timestamp.txt file for my server time. I need it to be +14400

2011-05-25T08:27:51 would essentially become 2011-05-25T10:27:51 when it writes to the timestamp.txt

I hope that makes sense.

J

What is the best way to insert this time stamp into mysql?  This is the info I want...

Example:  Sunday, 28.1.11, 9:56

How would I also select time from the database using mysql?

Hi!

The below dropdown will show dates/times every 15 minutes from 12am to 11:45pm for only 1 day.
I want it to show for 5 days, anyway I can do this?

Below code:

Code: [Select]
$start = strtotime('12:00am');
$end = strtotime('11:45pm');

echo '<select name="time">';
for ($i = $start; $i <= $end; $i += 900)
{
echo '<option>' . date('F j, Y, \a\t g:i a', $i);
}
echo '</select>';

Thanks for any help.

Hey,

I need help with date, I have stored dates in my table in this format:
i.e. 22.10.2011 but now use timestamp to store dates.

Problem is with this query the WHERE clause will find dates in the old format
and I want to change that to the new format.

Code: [Select]
for($i = $count; $i > 0; $i--)
{
$day = date("d.m.Y", mktime(0, 0, 0, date("m"), date("d") - $i, date("Y")));
$tmp = mysql_fetch_array(safe_query("SELECT count FROM ".PREFIX."counter_stats WHERE dates LIKE '%".$day."'"));
$array[] = $tmp['count'] ? $tmp['count'] : 0;
}

Am I making sense ?

I have a field set as datetime and want to compare that field to see if it is older then ten minutes. Can anyone help I am having a brain fart?