PHP - Having A Problem Formatting A Date

I'm going round in circles with this one, but I have a feeling that the answer is obvious.  I have POST information that I want to use as a date and display it using date format, but I don't know how to

The POST data outputs the following: 2011-9-23

Assuming I have defined $date as the posted data from the previous form, how do I write some code to tell it to output it as September 23, 2011, or just Sept 2011?

Hi Guys,

I have got a date string which looks like the following:
Quote

Thu Feb 09 2012 07:25:00 GMT 0000 (GMT Standard Time)


I need to convert it to Quote

d-m-Y H:i

format.

Any ideas on how to do this?

Thanks!

Hi all

I have a PHP script with the following var

print $date;

at the moment it is formatting the date like

03-24-2010

is it possible to get PHP to switch the date and month, so it looks like

24-03-2010

Thanks

To echo this:
      Posted on: October 23rd 2011

... I'm querying my db with this:
      DATE_FORMAT(creation_date, '%M %D %Y')


What if I wanted to echo this:
      23. Oktober, 2011

... that is, to display the date as it would be shown in German?

TIA if you can help.

I have selected datetime values from a MySQL database (originally stored with the NOW() method) and want to present them on a page formatted in a specific way. I succeded in making it work with the following php code:

$time = date('d/m Y H:i', strtotime($row['time']));
echo $time;

I am however unsure if this is the best way to do it? I noticed some comments at php.net stating that this method has some limitations due to UNIX time. I am confused. There seem to be many ways of formatting date and time. Maybe somebody can clarify the situation, and tell me what will be appropriate in the current situation? I will appreciate any suggestions ...   Erik 
Edited by erikla, 17 July 2014 - 10:01 AM.

I must admit that dates and timestamps really confuse me!

I have a query that gets a field named "date_purchased" and returns it like this "2010-09-05 09:58:12"

What I need to do is add one year to the date, and display it like this "September 5, 2011"

Basically, it's displaying the end date of a one year subscription.

The database captures the purchase date with the order, so I want to grab that, add a year, and display it to the customer.

Any help would be most appreciated!

How would I put today date for instance into mysql_query? I just want the date and have the format be year, month, day. The format in the database looks like 2010-04-05. That being used as an example. And I have three drop down menus, which you can select the year, month, and day, but it doesn't seem to be working. What am I doing wrong?

Hi all, new to PHP and had a syntax question. I have the following code:

print "<p>{$row['comment_createdate']};

This prints out a date from my sqlquery as a database datetime. I need to format it to display "Monday June 15, 2010 5:15 pm". I'm not sure how/where to attach a date() function to the record. (If it matters, the line above is inside of a loop going through several records). This really applies to attaching functions to columns within a recordset in general.

Many thanks ahead of time.

I have the date stored as: date( "d/m/Y" )

After it's pulled from the database, I would like it to display like:

date( "F j, Y" )

I have tried below, but the output makes d the month and m the day.

$dateStamp = strtotime($row['startrepeat']);
$dateFormatted = date("F j, Y", $dateStamp);

Currently the date is stored in the database as 28-02-2011 - 21:00:30 and the variable is: $date['mTime']

How can I format it too look "pretty" like this: February 28, 2011 - 10:00 PM? (don't need the seconds)

This topic has been moved to Third Party PHP Scripts.

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

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

Hi Guys...i have this problem... I have this page where user can type in their date of birth...I would like to convert the date of birth input by the user to the DATA format which is defined by phpmyadmin (YYY-MM-DD) so that i can put into the database... My main objective of this is to calculate age...

I have this form to allow use to type date of birth:
Code: [Select]
<label for="dob">D.O.B.: </label>
         <input type="text" name="dob" id="dob" class="regfields"/>
This is to store the input to a variable:
Code: [Select]
$adddob = $_POST['dob'];
and finally this query to insert all the input into the database:
Code: [Select]
$query = "insert into emp (FNAME, LNAME, CDSID, PAYNO, MAIL , TELNO , DOB , BRANCH , LICNO , CLASS , VFROM , VTO , EID , PASS , PIN) values ('$addfname','$addlname','$addcdsid','$addpayno','$addmail','$addtelno','$adddob','$addbranch','$addlicno','$addclass','$addvfrom','$addvto','$addeid','$addpassword','$addpin')";
Thanks in advance...If this is possible then I will set my dob column to the DATA format...

Code: [Select]
<?php
    $dayNames = array("Nedelja", "Ponedeljak", "Utorak", "Srijeda", "&#268;etvrtak", "Petak", "Subota");  
    $dan = $dayNames[date('N')];  
echo $dan.", ".date('d.m.Y.') ;
?> This is my code for showing days in my language, but it works on every day except sunday!  Does anybody have any clue?
Thanks!

Hi,

I have the date stored in my datrabase like this:

2010-04-03

I am then outputting the date like this:

Sat 13 Nov

This is done using this code:

list($year,$month,$day) = explode('-',$Coursedate);
$time_stamp = mktime(0,0,0,$month,$day);
$Coursedate2 = date("D d M",$time_stamp);

The problem I have come across is when listing a date for next year. The database has a value of 2011-01-29 which is a Saturday but it is outputting it as a Friday:

Fri 29 Jan

The 29th of January 2010 is a Friday but 2010 is a Saturday.

Any idea what is wrong with the code?