PHP - Converting To A Date Format

Hi guys I have this date script below which displays like so: 16/09/2011.

Its fine but I now like it to display like this: 16 September 2011

Please I need help in twicking the code to do this Thanks!

<?php
//check to see if passing variable is set i.e. if true get day, month, year.
if(isset($_GET['day'])){
$day = $_GET['day'];
} else{
//Get today's date and put them in date, month, year
$day = date("d");
}
if(isset($_GET['month'])){
$month = $_GET['month'];
} else{
$month = date("m");
}
if(isset($_GET['year'])){
$year = $_GET['year'];
} else{
$year = date("Y");
}

echo $day."/".$month."/".$year;

?>

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";
    }
    ?>

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 can't seem to get the syntax correct

I want my date outputted as January 1st.

Code: [Select]
<span class="goal_head f_right mrm"><?php echo date($goal['complete_date'], 'F j'); ?></span>

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?

  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?

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!

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,

I'm sure i have done this before, is there a way to shorten dates like:

December 16, 2010 to Dec 16, 2010    

and

January 16, 2010 to Jan 16, 2010

etc, i have used $dateFormatted2 = date("F j, Y", strtotime($d2)); to get the date format i have now.

any help would be appreciated

thansk guys

Graham

Code: [Select]
function time_ago($timestamp)
{
   //$months = array("Jan" => 31, "Feb" => 28, "Mar" => 31, "Apr" => 30, "May" => 31, "Jun" => 30, "Jul" => 31, "Aug" => 31, "Sept" => 30, "Oct" => 31, "Nov" => 30, "Dec" => 31);
   $curr_time = time();
   $time_ago = $curr_time - $timestamp;
   if($time_ago < 60) // seconds
   {
      $ext = $time_ago . " seconds ago..";
   }
   else
   {
      if($time_ago >= 60) // minutes
      {
         $time = floor($time_ago / 60);
         $seconds_remainder = $time_ago % 60;
         $ext = $time . " minutes " . $seconds_remainder . " seconds ago..";
         
         if($time >= 60) // hours
         {
            $hours = floor($time / 60);
            $minutes = $time % 60;
            $ext = $hours . " hours " . $minutes . " minutes ago..";
            if($hours >= 24) // days
            {
               $days = floor($hours / 24);
               $day_hours = $hours % 24;
               $ext = $days . " days " . $day_hours . " hours ago ..";
            }
         }
      }
   }
   return $ext;
}

Is there a cleaner approach to this?

Code: [Select]
function time_ago($timestamp)
{
//$months = array("Jan" => 31, "Feb" => 28, "Mar" => 31, "Apr" => 30, "May" => 31, "Jun" => 30, "Jul" => 31, "Aug" => 31, "Sept" => 30, "Oct" => 31, "Nov" => 30, "Dec" => 31);
$curr_time = time();
$time_ago = $curr_time - $timestamp;
if($time_ago < 60) // seconds
{
$ext = $time_ago . " seconds ago..";
}
else
{
if($time_ago >= 60) // minutes
{
$time = floor($time_ago / 60);
$seconds_remainder = $time_ago % 60;
$ext = $time . " minutes " . $seconds_remainder . " seconds ago..";

if($time >= 60) // hours
{
$hours = floor($time / 60);
$minutes = $time % 60;
$ext = $hours . " hours " . $minutes . " minutes ago..";
if($hours >= 24) // days
{
$days = floor($hours / 24);
$day_hours = $hours % 24;
$ext = $days . " days " . $day_hours . " hours ago ..";
}
}
}
}
return $ext;
}

It seems to work fine (was going to tackle Months but haven't done it yet), but anyway is there a better way to do this? I'm guessing there is as I wrote this up rather fast and I'm not that great with date math. Any suggestions are appreciated (besides maybe using ternaries which I'm working on atm).

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

Hi all,

I have done a script that works fine on a single basis...

SELECT * FROM company
WHERE so <> 0
AND so_active = 'yes'
AND DATE_FORMAT(so_start_date, '%e') = '18'
ORDER BY company_name ASC

The problem I have is when I try to do a range...

SELECT * FROM company
WHERE so <> 0
AND so_active = 'yes'
AND DATE_FORMAT(so_start_date, '%e') BETWEEN '5' AND '26'
ORDER BY company_name ASC

It should return at least 1 result as I am looking for '18', any help would be much appreciated.

Many Thanks.

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