PHP - Datetime Issues

I'm given something like this:
Sun Nov 06 2011 09:30:00 GMT-0500 (EST)

And i'm trying to turn that into
2011-11-06 09:30:00

I started by using explode and trying to loop through the day and month to figure it out, but that seems inefficient and overly complicated. Am i missing something?

Thanks

Basically I am using DATETIME to store the time in which a row was input.
Format - 2010-11-13 21:31:53
How would I get the current time of page load and compare it to the database row "2010-11-13 21:31:53" then output the difference.

Example
$sqlresult = 2010-11-13 21:31:53;
$currentTime = (GET CURRENT DATE+TIME = (2010-11-13 21:31:55) );

Output -
This was posted 2 minute's ago.

Thank you in advance. Any help would be greatly appreciated.

Hi Everyone,

Please have a look at this, and tell me if its right?
I am generating a sitemap for my website dynamically.

The date I am providing: 2012-02-24 11:56:09 and this is the output I am getting: 2012-02-24T11:56:09Z
now I am not sure of the Z at the end of the returned value.

I think I am looking for something similar to this: 2012-03-12T12:00:02+02:00

not to sure what I am doing wrong and where it gets the timezone from, I am guessing from the php config file.

any help would be much appreciated. thanks

My code:

Code: [Select]
<lastmod><?php echo $time->toAtom($post['Post']['modified']); ?></lastmod>

Hey, does anybody know a good function, where I can have the trendy "time ago" functionality?   A good tutorial would be cool, too.   I would be using the datetime function off MySQL.

I am trying to import into a csv file and filter the results to a particular user and only results based on the time the data was uploaded within one hour.  In other words anything not uploaded within the last hour of the start_time will not appear in the csv file.  Everything works fine except for the time part.  I get no results at all with the 'and unix_timestamp........   For all I know possibly I am way off with my effort.  The field name is start_time.  Here is code below.  Appreciate any help.

<code>  header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);
$then = time() + 3601;
$query = "SELECT * FROM ppb_listings where user_id = '4' and unix_timestamp(start_date) < $then";
$result = mysqli_query($conn, $query);
while($row = mysqli_fetch_row($result)) {
    fputcsv($fp, $row);
}
echo $result;
exit;

</code>

I have multiple datetimes. The format is dd-mm-yy, hh:mm. I want to insert it into a table using mysql. However mysql format is yy-mm-dd, hh:mm:ss. How can i do it and what type should i use (datetime?timestamp?).
Thanks for your help!!

Hi, basically i am parsing some rtf/word files and generating excel csv's for upload into mysql database....my issue is in one of the fields i want to store the value in the mysql datetime / date  format but excel keeps reformating it. Any help on how to overcome this will be highly appreciated.

I have a function that receives two datetime values attached to the variables $start and $end.  These will be in the format 'Y-m-d H:i:s'.

For each of these values, I create a DateTime object to make the handling of them easier:
Code: [Select]
$startDT = DateTime::createFromFormat('Y-m-d H:i:s', $start);
$endDT = DateTime::createFromFormat('Y-m-d H:i:s', $end);

What I need to do now is ensure that the seconds of the $startDT value are always set to '00' and the seconds of the $endDT value are always set to '59'.

Is there an easy way to do this without having to extract the individual values for hours, minutes and seconds before reapplying them using the setTime function, adjusting the values accordingly?

Hi, so I am trying to get how many minutes and seconds are left from the datetime entry in the database and the current datetime, but I'm having issues...

Here's my code:
Code: [Select]
$query = "SELECT RequestMadeDateTime FROM TempAwaitingClients WHERE PSOID = '2'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$RequestMadeDateTime = $row['RequestMadeDateTime'];
$currentDateTime = date('Y-m-d H:i:s');
echo 'Request Made Date Time: ' . $RequestMadeDateTime . '<br />';
echo 'Current Date Time: ' . $currentDateTime . '<br />';
echo date_diff($RequestMadeDateTime, $currentDateTime);

What I'm getting those is this, "Warning: date_diff() expects parameter 1 to be DateTime" ... Which I don't get because both variables are DateTime...

Hello,

I am trying create a news article, but I have few category in it. Can you help me to create an "add article form" which has dropdown list of category that I can choose, so when I select "Announcement" it will save the data on my mysql database under announcement table. sample html form below.

<form id="form1" name="form1" method="post" action="">
  <label>
  Category :
  <select name="category" id="category">
    <option>--- choose category ---</option>
    <option>News</option>
    <option>Announcement</option>
    <option>Sports</option>
  </select>
  </label>
  <br />
  Date: <br />
  Title:
  <label>
  <input type="text" name="title" id="title" />
  </label>
  <br />
  Body:
  <label>
  <textarea name="body" id="body" cols="45" rows="5"></textarea>
  </label>
  <br />
  <label>
  <input type="submit" name="Submit" id="Submit" value="Submit" />
  </label>
  <br />
  <br />
</form>

Can you tell me how to create the php code which support the above html.

Also, I would like to have a date and time on my article, but I want it automatically get the time and date from the computer of the client, so the user will not put it manually. can you point me to the correct code?


Thanks and hope you can help me!

I'm having trouble inserting a formatted PHP DateTime into a MySQL table.

I'm getting:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',2012-01-31)' at line 4

I get the error when I try to insert the date as a string from a DateTime object via:
$insertDate = $date->format('Y-m-d');

As well as when I try to recast it as a date object:
$insertDate = date("Y-m-d",strtotime($date->format('Y-m-d')));

I've also tried putting the date in ' ' 's and escaped " " 's.


My insert query is:
$insert = "INSERT INTO pendingordersdetails (PartNumber,Oqty,Pqty,Aqty,PartStatus,
PartPrice,idOrderNo,PrtTariffCode,PrtLocation,LineNum,PKqty,SPqty,AllocationDate)
VALUES ('$partNum',$oQty,0,$aQty,'Excess',$price,$orderNum,'$tariffCode',
'$location',$lineNum,$PKqty,$SPqty,'$allocDate');";

and the echoed output is:
INSERT INTO pendingordersdetails (PartNumber,Oqty,Pqty,Aqty,PartStatus, PartPrice,idOrderNo,PrtTariffCode,PrtLocation,LineNum,PKqty,SPqty,AllocationDate) VALUES ('0446535240 ',3,0,1,'Excess',163.89,66,' ', 'A0406E01',2,,,'2012-01-31');

Anyone have any ideas?

Hello,

I have a query that displays a list of events for the year, and am in need of guidance on how to have it only show events that are >= today's date. 

The 'date' is inserted into the table as a varchar field from javascript code.  There was an old blog post about doing something like....

Code: [Select]
SELECT * FROM calendar WHERE `date` >= NOW() ORDER BY date ASC LIMIT 5

I seem to have trouble in that i believe NOW() will only work with proper datetime entries as opposed to my varchar setup.

any help navigating this would be great.

I am preparing $begin and $end for DatePeriod() but I can't get passed this error "getting the error Recoverable fatal error: Object of class DateTime could not be converted to string".

$today = date("Y-m-d");
$datestop=$_POST['datestop'];
//echo "$today<br /><br />$datestop<br /><br />";
$begin = new DateTime("$today");
$end = new DateTime("$datestop");

 

Hi all,
I am currently storing dates and times for certain events in the following format:

$now= date('Y-m-d H:i:s');

This variable is then stored in a MySQL field of type DATETIME. I am looking for a way to query the database to return all results in a certain month, or within a certain time range, or a certain year etc.

How would this be achieved?

e.g. If I wanted to select everything for the year 2009, would it be:
SELECT * FROM table WHERE date BETWEEN '2009-01-01 00:00:00' AND '2009-12-31 11:59:59' ?

Thanks!

I have a varaiable which gets the server time;
$date =date("Y-m-d H:i:s");
suppose the server is in the USA then it the timezone of this date will be the timezone of USA.

And i want to convert this timezone to Asia/Karachi timezone.

Any Idea about this???