?
Solved

PHP Change Numeric Date to Text Date

Posted on 2009-03-31
10
Medium Priority
?
1,290 Views
Last Modified: 2013-12-13
Hello,
I'm trying to convert the date "20090328" into "March 28th, 2009" with PHP and getting a little stuck. I need this asap and don't have much time. Can someone fix up this code for me? Thanks!
<?php
		$file = "aaaaaaaaaa20090329aaaa";
		$file_date = substr($file, 10, -4); //get the date from the file name
		$file_year = substr($file_date, 0, -4); //get the year from the file date
		$file_month = substr($file_date, 4, -2); //get the month from the file date
		$file_day = substr($file_date, 6); //get the day (numeric) of the file
		$constructed_date = "$file_month/$file_day/$file_year";
		print($constructed_date);
?>

Open in new window

0
Comment
Question by:damijim
  • 6
  • 4
10 Comments
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 24031548
use strtotime and date function to do this.
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 24031599

<?php // RAY_temp_strtotime.php
 
// TEST DATA
$file = "aaaaaaaaaa20090329aaaa";
 
// GET DATE THING OUT OF STRING BY ANY CONVENIENT MEANS
$date = str_replace('a', '', $file);
 
// GET TIMESTAMP
$ts = strtotime($date);
 
// GET PRINTABLE DATE
$date_printable = date('m/d/y', $ts);
print_r($date_printable);

Open in new window

0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 24031639
Oops, sorry - need better date formatting.  Try this instead...
<?php // RAY_temp_strtotime.php
 
// TEST DATA
$file = "aaaaaaaaaa20090329aaaa";
 
// GET DATE THING OUT OF STRING BY ANY CONVENIENT MEANS
$date = str_replace('a', '', $file);
 
// GET TIMESTAMP
$ts = strtotime($date);
 
// GET FORMATTED DATE
$date_formatted = date('F jS, Y', $ts);
print_r($date_formatted);

Open in new window

0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:damijim
ID: 24031675
Well, I tried putting that code in to mine, and I end up with December 31, 1969 ...

the string passed was "aaaaaaaaaa20090329aaaa"
$file_date = substr($file, 10, -4); //get the date from the file name
$file_year = substr($file_date, 0, -4); //get the year from the file date
$file_month = substr($file_date, 4, -2); //get the month from the file date
$file_day = substr($file_date, 6); //get the day (numeric) of the file
$constructed_date = "$file_month$file_day$file_year";
 
// GET TIMESTAMP
$ts = strtotime($constructed_date);
// GET PRINTABLE DATE
$date_printable = date('F j, Y', $ts);
print_r($date_printable);

Open in new window

0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 24031687
Print out the $constructed_date and post it here, please.

What version of PHP are you using?

Thanks, ~Ray
0
 
LVL 1

Author Comment

by:damijim
ID: 24031711
PHP v5.2.3

output of $construct_date = 03302009

agh, my mistake, I can easily reorder the $construct_date variables if it's easier..
0
 
LVL 111

Accepted Solution

by:
Ray Paseur earned 2000 total points
ID: 24031731
Yes, - the strtotime() function can deal with YYYYMMDD format (which is ISO8601-format) so it's good to use that for all internal representations of the date.  

Best regards, ~Ray
0
 
LVL 1

Author Comment

by:damijim
ID: 24031751
Awesome, I switched it to:

$constructed_date = "$file_year$file_month$file_day";

and it's out putting what I want... Thanks!!
0
 
LVL 1

Author Closing Comment

by:damijim
ID: 31564949
Thanks again!
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 24031763
Glad to help, and thanks for the points.  You  can test any date string on my web site here:

http://www.laprbass.com/RAY_strtotime.php

Best always, ~Ray
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Measuring Server's processing rate with a simple powershell command. The differences in processing rate also was recorded in different use-cases, when a server in free and busy states.
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question