PHP - Reformat Date/time?

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

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

Hi,

I'm preparing a code for an automated email, but the date time is not working correctly. I wanted to do a cron scheduler that emails people twice a day - 9am and 9pm. 9am sends email about records logged starting 9pm yesterday to 9am, while 9pm sends email about records logged from 9:01am to 9:00pm. The database uses date/time, so I was doing an if statement of date time, but I wasn't getting the result I wanted.

Sometimes the $now time is not within the yesterday 9pm to the 9pm today range. I don't know what I'm doing wrong, but I'm sure that it has something to do with the if statement, as the some of the $now time enters the else statement

Here is my code:


<?php
$today = date('Y-m-d 00:00:00');
$nineyesterday = date('Y-m-d H:i:s', mktime(date("H") - (date("H") + 6), date("i") - date("i"), date("s") - date("s"), date("m") , date("d"), date("Y")));
$now = date('Y-m-d H:i:s', mktime(date("H") + 13, date("i"), date("s"), date("m") , date("d"), date("Y")));
$nineam = date('Y-m-d 09:00:00');
$nine30 = date('Y-m-d 09:30:00');
$ninepm = date('Y-m-d 18:00:00');
echo '9pm yesterday: '.$nineyesterday;
echo '<br/>';
echo '9am: '.$nineam;
echo '<br/>';
echo '9pm: '.$ninepm;
echo '<br/>';
echo 'now: '.$now;
echo '<br/>';


if ((strtotime($now) > strtotime($nineyesterday)) and  (strtotime($now) <= strtotime($nineam)))
{
//count the answers by yes or no
echo 'am';

}
elseif ((strtotime($now) > strtotime($nineam)) and  (strtotime($now) <= strtotime($ninepm)))
{
//count the answers by yes or no
echo 'pm';
}
else
{
echo 'error';
}
?>


Thanks in advance

Are time zones when calling the date function automatically decided based on where you live? Or is that something that I have to implement--Because the time is wrong according to my time zone.

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

I'm having some trouble understanding how to use date and time when updating my database.
The table is already populated with Date and Time fields in date and time format. I need to update the table based on the date and time, but I can't make it work. I tested all the variables and they are being sent correctly.
I'm pretty sure the problem lies in how I'm trying to match the Date and Time fields with $dateID and $timeID in the WHERE part of the query, but I'm not sure how to fix that!
Code: [Select]
<?php

include("opendatabase.php");

$size = count($_POST['player1']);
$i=0;
$thisyear = date("Y");

while ($i < $size)
     {
     $dateID = $_POST['date'][$i];
     $timeID = $_POST['time'][$i];
     $player1 = ($_POST['player1'][$i]);
     $player2 = ($_POST['player2'][$i]);
     $player3 = ($_POST['player3'][$i]);
     $player4 = ($_POST['player4'][$i]);
     $player5 = ($_POST['player5'][$i]);

mysql_query("
UPDATE Daysheets$thisyear
SET 
        Player1='$player1',
        Player2='$player2',
        Player3='$player3',
        Player4='$player4',
        Player5='$player5'
 
WHERE Date = '$dateID'
AND Time = '$timeID' ");
     $i++;
}

header("Location: /teetimes/publicteetimes.php?teetimedate=$dateID");

mysql_close($con)

?>Any help appreciated!
I should also mention that whenever I run this query it erases anything that was previously entered in the database except the date and time columns...

$date=2010-11-01 23:45:09

How do I create one variable to output Monday November 1 and another variable to display 11:45:09 PM from the above variable.

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

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

I have a form that has this:

Code: [Select]
<input type="text" name="notes_date" size="10" value="<?php echo date("m/d/Y");?>" />
I enter into the database after processing the variable like this:
Code: [Select]
$notes_date=date ("Y-m-d H:i:s", strtotime($_POST['notes_date']));
However, it gets stored at 2012-03-15 00:00:00

How do I fix this so that the current time gets stored instead of 00:00:00?

.