PHP - Modifying The Format Of Date And Numbers

Anyone know what's up with this?


<?php
    $days = floor($posts['timestamp'] / (60 * 60 * 24));
    $remainder = $posts['timestamp'] % (60 * 60 * 24);
    $hours = floor($remainder / (60 * 60));
    $remainder = $remainder % (60 * 60);
    $minutes = floor($remainder / 60);
    $seconds = $remainder % 60;
           
    if($days > 0) {
    echo date("d/m/y", $posts['timestamp']);
    echo " at ";
    echo date("H:i", $posts['timestamp']);
    }elseif($days == 0 && $hours == 0 && $minutes == 0) {
    echo "few seconds ago";
    }elseif($days == 0 && $hours == 0) {
    echo $minutes.' minutes ago';
    }elseif($days == 0 && $hours > 0){
    echo $hours.' hour ago';
    }else{
    echo "few seconds ago";
    }
    ?>

  Code: [Select]
$date =date("d F Y");
It will display 18 October 2011.
If I need it to display 2011-10-18. How do it go about coding it?

Hi Guys

Could somebody tell me how i would put a line break into the code below

i.e:
1.07 <br />
2010


<?php echo date('d.m.Y',strtotime($news['created_at']));?>


Thanks for your help

I have a date field in the database table of this format 2012-02-08.
Now I want to select fields from the database where date >= $currentdate.
Do I have to do someting like
$currentdate=time();
//Then convert it into YYYY-MM-DD format?

Hi Guys   In MYSQL the date format seems to be YYYY-MM-DD, when I use a dynamic table in Dreamweaver the date is also displayed this way, is there a simple way to change this to UK format DD-MM-YYYY?

I am trying to get the full date from form field using the date function and post method.

$fromdate = $_POST[‘sdate’];
$todate = $_POST[‘edate’];
$fromday = date(‘F j, Y, g:i a’,’$fromdate’);
$today1 = date(‘F j, Y, g:i a’,’$todate’);

When trying to print i get the right format but i get extra information not sure from where? I am getting the date from the form fields of type date.

Code Output:

March 19, 2020, 4:16 pm,$31202019pm31Asia/Dubai

why i am getting the second part!

What Date Format is this...
Code: [Select]
echo '<div class="date">Published: ' . date('F j, Y', strtotime($publishedOn)) . '</div>';
And where can I find a listing of the different Date and Time Formats that will work with this?

(I would like to display my date as "2012-02-26  2:40pm" for what it is worth...)

Thanks,


Debbie

I'm trying to format a date to use in a mysql query and was wondering about the best way to do it.

the form returns: mm/dd/yyyy and I need to format it to yyyy-mm-dd, any help would be greatly appretitaed, thanks in advance!

Hi,
I'm struggling a bit with using a date format and strtotime()

Code: [Select]
if(!empty($_GET['utime']))
{
$time = strtotime($_GET['utime']);
}

utime is supplied in the format dd/mm/yyyy but when I use strtotime() it treats it as mm/dd/yyyy....so 07/12/2011 is taken as 12th Aug rather than 7th Dec..which is the date I want to use.

I had a quick ganders through the forums but couldn't find anything specific to this.

is there any other attributes to strtotime() that will help, or a similar fucntion or a neat way of swoping my dd/mm/yyyy round before i use strtotime()

any help greatly appreciated...

I have a db with db with date and the format for the date is 1975-12-22 and I want them to appear as 1975-DEC-22
I don't mind changing the date from date to varchar to make this happen maybe pulling each record and using find and replace or something. What would be the best way to make this happen.

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

when trying to get the date

var visitors_time = new Date();

i'll being back a result like

Mon Oct 27 2014 20:54:55 GMT+0000 (GMT Standard Time)

my issue is, is there a way of getting the end part with the brackets to not show up? ie. format the date?...ive googled but doesnt seem no simple solution like php to actually format the date to the way you'd like it   thank you guys

Hi i've been trying to change the format of the date which comes from the database row [ news-date ]
this what i tried but di not work help please

$query = "SELECT * FROM news, date_format [news_date](date,'%M %d, %Y') AS news_date
 "; 
$result = mysql_query($query); 

// see if any rows were returned 
if (mysql_num_rows($result) > 0) { 
 // yes so print them one after another 
  echo "<table cellpadding=10 border=1>"; 

  while($row = mysql_fetch_array($result))  {
  
   
  

     echo "<tr>"; 
     echo "<td>".$row["news_id"]."</td>"; 
     echo "<td>".$row["subject"]."</td>"; 
     echo "<td>" .$row['news_date']. "</td>";
 
     echo "<td>".$row["news_artical"]."</td>";
 echo "<td><a href=delete2.php?id=".$row["id"].">Delete</a></td>"; 
 echo "<td><a href=modifyform.php?id=".$row["id"].">Modify</a></td>";
 echo "<td><a href=add.php?id=".$row["id"].">Add Row</a></td>";
     echo "</tr>"; 
   } //End While
   echo "</table>"; 
} //End if rows 

   echo "<p> <strong>{news.SUBJECT} </strong></p>"; 



?> 

Hi there,

i want to convert whatever a user inputs through and html form to a DATE format which when posted will be entered (using mysql) as that particular Date format , i'm using this:

Code: [Select]
$date = "12-12-11"; //assume this to be the user input

$time = strtotime($date);
$new_date = date("d/m/Y",$time);
                echo $new_date;

but this format will give the output as:  11/12/2012.....is there a way to convert whatever the user enters to be: dd/mm/yyyy which gives: 12/12/2011
thanks so much

I need to change the date format to DD-MM-YYYY. Please help.

$SomeVar = $_POST['finco'];
$query = "SELECT * FROM  news_home WHERE code = '".$SomeVar."' ORDER BY timestamp DESC";
$results = mysql_query($query);

$returnS="";
while($line = mysql_fetch_array($results))
{
$returnS.= $line["subject"].",,".$line["timestamp"].",,".$line["News"].",,".$line["links"].",,,";
}
echo $returnS;
mysql_close($link);
?>