Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

PHP Change Numeric Date to Text Date

Posted on 2009-03-31
10
Medium Priority
?
1,279 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 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

722 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