I'm going crazy! Date formatting issue!!!! HElp@!

mykidisgollum

Problem:
I have the following unix timestamp as a var: 2003-10-02 08:00:00
The var is $start_datetime.

I need to use the date function like so:
date('m/h/Y', $start_datetime) to make the date formatted better.

My problem is that date('m/h/Y', $start_datetime) = 12/06/1969

So I thought, ahh - for some reason it's not a correctly formatted timestamp, so I tried:

date('m/h/Y', strtotime($start_datetime)) = 10/08/2003 - what happened here? - looks like strtotime gave me the 8th?

What is the deal! I've worked for over an hour on this! I want 10/02/2003! See something I'm missing? For codeflow reasons, I'd rather not use mysql to format this string for me.

Any assistance is appreciated!

bad76

Hi,
your problem is start value. Timestamp is a progressive number from Unix-date. Try to use mktime() to get an exact timestamp:

          //be care, months are before days...
$start_datetime=mktime(8,0,0,10,2,2003);

i hope this help

mykidisgollum

I"m confused by what you mean about timestamp. what is wrong about the format for my timestamp as I posted it?

I guess I could always substr my timestamp string to make my date, but that seems cheesy. - Since I don't have all those values as in your mktime parameters, I'd have to make them manually.

YappyDog

The biggest problem is with your date format string.

The "h" in your string represents the hour of the timestamp. You should be using "d".

echo date('m/d/Y'), strtotime($start_datetime));

mykidisgollum

Works great now m -> d!