Php Date-Formatting Help

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Hello All,

I have a date value that I pull from a .csv file.
After reading the file and storing the values in an array the value of
the date could
be found in $array[1], for example.
while (($data = fgetcsv($handle,5000, ",")) !== FALSE) {
     $mydate = $data[3]; // here is the array value that holds the date
The date will be in either m/d/yyyy or mm/dd/yyyy format.
Here is the problem.  I need to display this date on the page
in "long" format - i.e. January 5, 2005 instead of 1/5/2005 or

I have tried to use the date() function, however I can only get the
formatting to work
with the current date and not with an 'existing' date.

date("d.m.Y", $mydate); // this does not work, I get a date from

Any advise would be greatly appreciated!


Re: Php Date-Formatting Help wrote:

Quoted text here. Click to load it


advise is simple: RTFM.
Or more friendly: Your answer can be found if you actually read the  
functiondefinition at

Here is a part:

(PHP 3, PHP 4, PHP 5)
date -- Format a local time/date
string date ( string format [, int timestamp] )

Returns a string formatted according to the given format string using the  
given integer timestamp or the current local time if no timestamp is given.  
In other words, timestamp is optional and defaults to the value of time().  

So what timestamp did you excactly give?
A timestamp is NOT string that represents a date, but a number.

What you need (from the same page at is a function to make a  
timestamp from a stringrepresentation of a date. That function is called  

Look it up. :-)

Good luck.

Erwin Moller

Re: Php Date-Formatting Help

Erwin Moller wrote:

Quoted text here. Click to load it

The route I take with date formatting from the mm/dd/yyyy or dd/mm/yyyy
formats is generally:

echo(date("F jS, Y",mktime(0,0,0,$month,$day,$year)));


Site Timeline