asked on

php How to strip zero's from month and day date

hi,
the code below is grabing dates from my db that I need to use in jquery datepicker.

my problem is that my dates from the db are in the wrong format that my datepicker is accepting.

right out of the db the format is "2010-09-09,2010-09-17,2010-12-05" etc

The datepicker does not like the zero's infront of the month's or days it prefers the format below:
"2010-9-9,2010-9-17,2010-12-5"

How can I strip the zero's out of the "arrayy" array only if they exist?

thanks!

$string =  $dated["start_date"];
$fresh = substr($string, 0, -9); // removes the time and leaves date from stamp


$arrayy[]=$fresh;



}

echo "<script>";

echo "var disabledDays = new Array();";



foreach($arrayy as $key=>$value) {
 echo "disabledDays[$key] = \"$value\";";
   
}

echo "</script>";

Open in new window

leakim971

Use (client side) : myDate.replace(/-0/g,"-");

test page :

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<script language="javascript">
	var myDates = "2010-09-09,2010-09-17,2010-12-05";
	alert( myDates.replace(/-0/g,"-") );
</script>
</body>
</html>

Open in new window

ASKER CERTIFIED SOLUTION

leakim971

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

shobinsun

HI,

try this example:

$TR = "2010-09-09";
$st = preg_replace(array('/-0/'), ' ', $TR);
$st1 = preg_replace(array('/ /'), '-', $st);

Chris Stanyon

Convert your database date to unix timestamp (strtotime) and then format that using DATE - Y for 4 digit year, n for months without leading zeros, and j for days without leading zeros.

echo date("Y-n-j",strtotime($dated["start_date"]));

Open in new window

leakim971

In your MySQL : select replace(myDate,"-0","-") as myDate from myTable

test page lol :

select replace("2010-09-09","-0","-") as "myDate" from dual

select replace("2010-09-09,2010-09-17,2010-12-05","-0","-") as "myDate" from dual

Open in new window

leakim971

Thanks for the points!