PHP - Time Date Different Languages

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?

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.

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

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 just recalled using date(); time() for lots of things in my database, including post times etc. At first I simply assumed this used server time or something, but when I changed my PC's time, it changed ! Now, shortly after this I simply assumed this was because of me using a localhost? But I am not certain anymore..

If I would place this online, would date() and time() return you server time or user time? I couldnt find it on google =-(

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

}

 

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

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

I have selected datetime values from a MySQL database (originally stored with the NOW() method) and want to present them on a page formatted in a specific way. I succeded in making it work with the following php code:

$time = date('d/m Y H:i', strtotime($row['time']));
echo $time;

I am however unsure if this is the best way to do it? I noticed some comments at php.net stating that this method has some limitations due to UNIX time. I am confused. There seem to be many ways of formatting date and time. Maybe somebody can clarify the situation, and tell me what will be appropriate in the current situation? I will appreciate any suggestions ...   Erik 
Edited by erikla, 17 July 2014 - 10:01 AM.

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 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 am writing an app that takes ofx banking files files on convert them to csv for excel or importation into sql. I am on the last task. Converting the nonstandard date:time stamp. I am using preg_replace(). I am not the best at regular expressions. I am getting this error: "Warning: preg_replace() [function.preg-replace]: Unknown modifier '\' in C:\xampp\htdocs\banking\ofx-date.php on line 13"

CODE:
        // Date Time 20110228000600 (2011/02/28/, 00:06:00)
        // Expected Return '<DTPOSTED>2011/02/28,00:06:00'
       
        $ofxDate = '<DTPOSTED>20110228000600';
        $ofxNewDate =  substr($ofxDate,0,10) . substr($ofxDate,10,4) . '/' . substr($ofxDate,14,2) . '/' .
            substr($ofxDate,16,2) . ',' . substr($ofxDate,18,2) . ':' . substr($ofxDate,20,2) . ':' . substr($ofxDate,22,2);
        echo htmlentities($ofxNewDate) . PHP_EOL;;
       
        $patternA = '/<DTPOSTED>/\b[0-9]+\b';
        //$replacement = '/<DTPOSTED>/';
       
        $stringB = preg_replace($patternA, $ofxNewDate, ofxDate);
        echo htmlentities($StringB) . PHP_EOL;