0

Hello

I want to convert the date formate from

Wed Jun 15 2011 00:00:00 GMT 0530 (India Standard Time)

to

06/06/2011

I have done something like this

$chkdt = "Wed Jun 15 2011 00:00:00 GMT 0530 (India Standard Time)";
	$month = substr($chkdt,4,3);
	if($month == 'Jan') $month = '01';
	else if($month == 'Feb') $month = '02';
	else if($month == 'Mar') $month = '03';
	else if($month == 'Apr') $month = '04';
	else if($month == 'May') $month = '05';
	else if($month == 'Jun') $month = '06';
	else if($month == 'Jul') $month = '07';
	else if($month == 'Aug') $month = '08';
	else if($month == 'Sep') $month = '09';
	else if($month == 'Oct') $month = '10';
	else if($month == 'Nov') $month = '11';
	else if($month == 'Dec') $month = '12';
	
	$date = substr($chkdt,7,3);
	$year = substr($chkdt,10,5);
	$finaldt = date("m/d/Y", mktime(0, 0, 0, $month, $date, $year));

its working fine and give me the result which i want. but i don't want to use this if condition for the each month. is there any other solution for convert the date in same formate which i want ?

Thanks in advance :)

5
Contributors
6
Replies
9
Views
6 Years
Discussion Span
Last Post by almostbob
1

Check this.

<?
	echo $strDate = substr('Wed Jun 15 2011 00:00:00 GMT 0530',4,11);
	echo '<br />'.date('m/d/Y', strtotime($strDate));
?>
Votes + Comments
Thanks for your help. it solved my problem.
0
$chkdt = "Wed Jun 15 2011 00:00:00 GMT 0530 (India Standard Time)";
$chkdtarr=explode("GMT",$chkdt);
$newdt= strtotime($chkdtarr[0]);
echo $newdt;
echo "<br>".date("m/d/Y",$newdt);
0
<?php

function getTime($date,$inctime=true,$tz1="Europe/London",$tz2="Asia/Kolkata"){
	date_default_timezone_set($tz1);
	$int = strtotime(substr($date,0,24));
	date_default_timezone_set($tz2);
	$tm = ($inctime) ? ' H:i:s' : '';
	return date("d/m/Y$tm",$int);
}

echo getTime("Wed Jun 15 2011 10:00:00",true);

?>

//OOPS, OK just saw the GMT +530 bit - so your time is already,local - no need to convert, as mentioned previously, just split the string and use strtotime.

Edited by diafol: n/a

-2

you could fix your database design by a tableupdate now, and
store only a timestamp,
use 4bytes per record instead of 35,
require simpler code to select records,
simpler code to update the table,
simpler code to display
allow any user to have the date and time formatted to their preference, or their country code standard

correct the problem, intead of patch it, and make the whole thing much easier elseif() is fractionally faster than else if()

Edited by almostbob: n/a

Votes + Comments
your answer is not related to the question.
0

@ all
thanks for your help. Its working for me :)

@almostbob
I am not store this formate into db this date value I get it from event calender and I can't change that calender so I have to convert this date into my required formate.

0
$chkdt = "Wed Jun 15 2011 00:00:00 GMT 0530 (India Standard Time)";
$finaldt = date("m/d/Y", strtotime($chkdt));

and still repair your data

Edited by almostbob: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.