PHP - Changing Date Format

Hi,
  I have a date and time stored in a database field (publishdate) and I'm using php to fetch it and display it in an HTML table. Only problem is it shows up in epoch time. I can't get it to display in human readable time for some reason. Here's the code I'm using (it's automatically generated by some software)

// View column for publishdate field
            $column = new TextViewColumn('publishdate', 'Publishdate', $this->dataset);
            $column->SetOrderable(true);

Many thanks in advance.

Tony

I have tried a large number of "solutions" to  this but everytime I use them I see 0000-00-00 in my date field instead of  the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year.  Using the POST array, I  have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql. 

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure  that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

Hi there,

I have a string '12/04/1990', that's in the format dd/mm/yyyy.

I'm attempting to convert that string to a Date, and then insert that date into a MySQL DATE field.

The problem is, every time I try to do so, I keep getting values like this in the database: 1970-01-01.


Any ideas?


Much appreciated.

Hi guys, first and foremost I’m not a programmer, but I do have a little problem that I need help with. I have a website and there is a members registration form, within this form there is a Telephone field.   The telephone field requires a certain format e.g. 138 xxxxxxxxx, I would like your help on how to change the format, so that I can input random numbers.   where and how should I be editing this field to achieve the required result?   Thanks in advance.

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

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;

?>

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!

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!

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?

  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,

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

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

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