Solved

PHP Change Numeric Date to Text Date

Posted on 2009-03-31
10
1,271 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 110

Expert Comment

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

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 110

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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
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 110

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 110

Accepted Solution

by:
Ray Paseur earned 500 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 110

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

751 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