PHP - Subtract Date And Time From Another Date And Time, Display Difference.

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?

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

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.

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?

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

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'm trying to pull data from a mysql db. I've stored data on the mysql with the date/time property. So How can I pull the mysql data by date/time?

I have a time and date using the code

echo date("l jS \of F Y H:i:s.");

Now I need to show this in several different languages, including French German and Dutch

I have tried setlocale();
and echo strftime

The date shows but still in English.
Any idea how to show the day date and time in Php for the languages suggested.

how to calculate the difference between the current datetime  from the stored one(ie date_field = 2020-08-09 23:13:06) in order to compare with 15min, i mean  if the resulted time exceed 15 min and not the same day(date) the provided link will show  expire message.

i.e $some_variable = $date_in_db - current_date;

if((time() - $some_variable > 15*60) && not the same day or the same day){

echo 'the link has expired';

}

 

Is it possible to convert time(); to date();?

the TIMESTAMP from mysql returns in this format: 2012-04-20 14:25:50

How could I rearrange this with PHP to read as: 04/20/2012 14:25

Thanks

I'm looking to enter the current time and date into a mysql database using php.  My current code looks like this:

Code: [Select]
$now = date("m/d/y",time());
I then insert $now into the table into a datetime column.  This all works but the time when read from the column appears as 0000-00-00 00:00:00.

Any ideas what I'm doing wrong?

Thanks in advance.

I want the current date to be displayed in this format:
year-month-day hr:min:sec
Suggest me some functions or codings

Hi there, what I have been trying to do is add some additional logic.. My problem is I want to stop displaying the month and day after the year 2000? I know I need to add an if and else statement but this is my first actual project and I am a little stuck.. here is the page, it's a plugin for a timeline http://www.llandover...oject-timeline/   And the file is attached below.. any help would be appreciated. The plugin code was too long to just post in here, didn't want to cause any slow loading issues for people on a slow connection.. Thanks and I appreciate any help.    Attached Files  annual_archive.php   18.15KB   5 downloads