converting date for db entry

Paul_Ferrie

Hi guys,
I am sure i am over looking the obviuos.

Users supplies date: 12/06/05

I take that and covert it using date() and strtotime()

but for some reason the wrong date is entered into the database.

$calDate = "12/06/05";
$calDate = date("Y-m-d", strtotime($calDate));

Cheers
Paul

tekky

Uhm what date is it entering?

June-12-05?

We cant help without details....

inputted data...
outputed data...
expected data...

Paul_Ferrie

Thats a bit harsh, it pretty obviuos what i am trying to do.

i want to take 12/06/05
and convert to 2005-06-12

Date output 2006-01-06
Thanks

Frederick

Try using explode()

$input_date = "4/18/05";

$split_time = explode("/",$input_date);

$conv_time = mktime(0,0,0,$split_time[0],$split_time[1],$split_time[2]);

echo date("m-d-y",$conv_time);

Paul_Ferrie

Thanks Frederick, i did think of that but i am not good enough to go build it. I did think that strtotime() could take 12/06/05 and do the conversion?

tekky

Originally posted by Paul Ferrie
Thats a bit harsh, it pretty obviuos what i am trying to do.

i want to take 12/06/05
and convert to 2005-06-12

Date output 2006-01-06
Thanks

WTF?!?!? I want to solve your problem, not work around it, but hell here's a work around enjoy

$date = '12/06/05';
list($day,$month,$year) = explode('/',$date);
$date = date('m-d-y', mktime(0,0,0,$day,$month,$year);

enjoy, I hope that example isn't too harsh for your sensitive eyes...

tekky

Originally posted by Paul Ferrie
Thanks Frederick, i did think of that but i am not good enough to go build it. I did think that strtotime() could take 12/06/05 and do the conversion?

the problem lies in the ambiguity of your date... hence my first post... which was obviously totally out of line

is that June, or December?

Read this...

Paul_Ferrie

Sorry i should have pointed out that it is uk date format dd/mm/yy
I did think about doing explode on the date but i am sure there was an easier way. i am not a php guru or anything but thought there would have been an easier way to do this. You mentioned this is a work around?

thanks
Paul