PHP - Date Time Question

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!

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

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 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

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';

}

 

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

hi,

I have some code that deals with sending out reminders for appointments due the following day.

So if today is the 21/3 then only reminders for appointments due on the 22/3 should be sent.

Currently this isn't happening...
 
If reminders are sent on 21/3 at 9.50 am, my code adds 24 hours to this datetime and sends reminders due for all
appointments that fall bewteen 21/3 9.50am and 22/3 9.49 am.

What I want to do is simply send all reminders for appointments that are on the 22/3 exclusive of time.

I'm not sure how do this in php, which uses the unix datetime format to mildy complicate issues

anhy help or solutions would be massive, thanks.how to


Code: [Select]
$days = time() + (1 * (60 * 60 * 24));
$apts = $db->fetch_all('status = 1 AND time > ? AND time < ?', array(time(), $days));

Okay, I have this form system/processor I have programmed and I am having a minor issue. When the form data is sent via email I want the date/time the user submitted the information included in the email, mainly for records. Now, I thought using $_SERVER['REQUEST_TIME'] would work, but it is returning a value of "1320019222" in the email, any tips on how to fix this??

Thanks!!

hi all,

i have a script that im trying to add the @ sign after the date.

code:
Code: [Select]
<td align='left' class='forumheader3' nowrap>".(($wardate == -1) ? "" : date($conf['formatdetails'], $wardate))."</td>
resulting in this:
Code: [Select]
1 Apr 2012 21:30
but i am trying to get the @ after the date so the result would be this:
Code: [Select]
1 Apr 2012 @ 21:30
any help please

hello i got this small function i`m working on to get the date of a month something like get current date - 1 but not sure how to handle jan month can someone help me please ?



$month = date('m') - 1;
$date_startt = date('Y').'-'.$luna.'-01';
$timestamp_start = strtotime($data_start);

I'm trying to make $time be a variable with the current time and I want it to have the same format as mysql.  I can't figure out what I am doing wrong here

Wrror: Warning: date_format() expects parameter 1 to be DateTime, integer given

Code: [Select]
$time = date_format(time(),'Y-m-d H:i:s');