PHP - Check Date Is In Format Of Y-m-d

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

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

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

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

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!

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=311729.0

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

Hey,

I have a database with a date field that has the date in this format:

August 2, 2010 11:04 pm

I was wondering if it was possible to change this so I have the day, month and year in separate variables like this:

$day = "2";
$month = "8";
$year = "2010";

Also notice how I have changed August to "8". I was wondering if there was an easy way around getting this done?

Thanks in advance

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

while I'm reading the cell value '20/09/1980' from an excel file using phpexcel class method

 $student[$i]['d_o_b'] = $objWorksheet->getCell('G' . $intRow)->getValue();

 getting the value as '29484' pls help me to convert it into the date format again.

Hey, I am grabbing a date from a row in my table which is currently formatted as:
date("Y-m-d")
2010-09-29

So in my code I have something like this:

$row['date'];

How do I use this to rearrange the date to look like:

09-29-2010

I looked at the formatting tutorials, but they explain how to format it for the date you are currently setting into a variable.

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



?>