get free code

Mostly in PHP you need to get the date and time in MySQL datatime data field format. So following is short php code to do that.

$dateFormat = 'Y-m-d H:i:s';
$timeStamp = time();
$dateTime= date($dateFormat,$timeStamp);
echo $dateTime;
?>


or
// set the default timezone to use. Available since PHP 5.1
date_default_timezone_set('UTC');


// Prints something like: Monday
echo date("l");

// Prints something like: Monday 8th of August 2005 03:12:46 PM
echo date('l jS \of F Y h:i:s A');

// Prints: July 1, 2000 is on a Saturday
echo "July 1, 2000 is on a " . date("l", mktime(0, 0, 0, 7, 1, 2000));

/* use the constants in the format parameter */
// prints something like: Mon, 15 Aug 2005 15:12:46 UTC
echo date(DATE_RFC822);

// prints something like: 2000-07-01T00:00:00+00:00
echo date(DATE_ATOM, mktime(0, 0, 0, 7, 1, 2000));
?>


or
$tomorrow = mktime(0, 0, 0, date("m") , date("d")+1, date("Y"));
$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"), date("Y"));
$nextyear = mktime(0, 0, 0, date("m"), date("d"), date("Y")+1);
?>

or
// prints something like: Wednesday the 15th
echo date("l \\t\h\e jS");
?>

or
// Assuming today is March 10th, 2001, 5:16:18 pm, and that we are in the
// Mountain Standard Time (MST) Time Zone

$today = date("F j, Y, g:i a"); // March 10, 2001, 5:16 pm
$today = date("m.d.y"); // 03.10.01
$today = date("j, n, Y"); // 10, 3, 2001
$today = date("Ymd"); // 20010310
$today = date('h-i-s, j-m-y, it is w Day'); // 05-16-18, 10-03-01, 1631 1618 6 Satpm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.'); // it is the 10th day.
$today = date("D M j G:i:s T Y"); // Sat Mar 10 17:16:18 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h'); // 17:03:18 m is month
$today = date("H:i:s"); // 17:16:18
?>


or

function weekStartEnd($date)
{
$dateArr=explode("-",$date);
//1-7 , monday-sunday
$dayInWeekNo=date("N", mktime(0, 0, 0, $dateArr[1],$dateArr[2],$dateArr[0]));

$weekStartEndPosition=array(
1=>array("start"=>0,"end"=>6),
2=>array("start"=>-1,"end"=>5),
3=>array("start"=>-2,"end"=>4),
4=>array("start"=>-3,"end"=>3),
5=>array("start"=>-4,"end"=>2),
6=>array("start"=>-5,"end"=>1),
7=>array("start"=>-6,"end"=>0)
);

$weekStart=date("Y-m-d",
mktime(0,0,0,$dateArr[1],
$dateArr[2]+
$weekStartEndPosition[$dayInWeekNo]["start"],
$dateArr[0]));

$weekEnd=date("Y-m-d",
mktime(0,0,0,$dateArr[1],
$dateArr[2]+
$weekStartEndPosition[$dayInWeekNo]["end"],$dateArr[0]));

return array("start"=>$weekStart,"end"=>$weekEnd);
}
?>