PHP - COMMON DATE FORMATS

Two Digit, 12hr:
08/25/2005 03:12:46 PM
date('m/d/Y h:i:s A');

MySQL to Calendar with time:
2005-08-25 15:12:46 => 08/25/2005 03:12:46 PM
date('m/d/Y h:i:s A',strtotime($row['date_entry']));

MySQL to Calendar without time:
2005-08-25 => 08/25/2005
date('m/d/Y',strtotime($row['date_entry']));

Calendar to MySQL with time:
08/25/2005 03:12:46 PM => 2005-08-25 15:12:46
date('Y-m-d H:i:s',strtotime($date_entry);

Calendar to MySQL without time:
08/25/2005 => 2005-08-25
date('Y-m-d',strtotime($date_entry);

Fix SQL-server:
8/25/2005 03:12:46 PM => 08/25/2005 03:12:46 PM
date('m/d/Y h:i:s A',strtotime($row['date_entry']));

SQL-serverize:
08/25/2005 03:12:46 PM => 8/25/2005 03:12:46 PM
date('n/j/Y h:i:s A',strtotime($date_entry));

Readable:
Monday 25th of August 2005 03:12:46 PM
date('l jS \of F Y h:i:s A');

RSS-XML:
Thu, 27 Jan 2011 14:44:40 -0700
date('D, j M Y H:i:s -0700');

Compare Time
if(time() - strtotime('')<60){
    /*one minute passed*/
}

JS - DATES

Formatted Date/Time
var d=new Date;
var datetime=(d.getMonth()+1)+'/'+d.getDate()+'/'+d.getFullYear()+' '+d.getHours()+':'+d.getMinutes();
var dateonly=(d.getMonth()+1)+'/'+d.getDate()+'/'+d.getFullYear();
var timeonly=d.getHours()+':'+d.getMinutes();

Unix Timestamp
var uts=Math.floor(Date.now()/1000);

Text to Unix Timestamp
var d = Math.floor(Date.parse('March 21, 2012'));

Formatted Date/Time with Offset (milisecs)
var d=new Date;d.setTime(Date.now()+3600000);
var datetime=(d.getMonth()+1)+'/'+d.getDate()+'/'+d.getFullYear()+' '+d.getHours()+':'+d.getMinutes();
var dateonly=(d.getMonth()+1)+'/'+d.getDate()+'/'+d.getFullYear();
var timeonly=d.getHours()+':'+d.getMinutes();

Transfer Date And Time Fields To Datetime Field
(UNIX Timestamp)
function dateAndTimeToTimestamp(date_id, time_id, datetime_id){
dateTimeString=document.getElementById(date_id).value;
var time_string='';
if(document.getElementById(time_id).value.indexOf(':')>-1){
var time_segments=document.getElementById(time_id).value.split(':');
time_segments[0]=new Date('2000-01-01 ' + document.getElementById(time_id).value).getHours();
time_segments[1]=time_segments[1].substr(0,2).padStart(2,'0');
time_string='T'+time_segments[0].toString().padStart(2,'0')+':'+time_segments[1]+':00';
}
document.getElementById(datetime_id).value=Date.parse(dateTimeString+time_string)/1000;
if(document.getElementById(datetime_id).value=='NaN'){
document.getElementById(datetime_id).value='0';
document.getElementById(date_id).style.backgroundColor='#ffeeee';
document.getElementById(time_id).style.backgroundColor='#ffeeee';
}else{
document.getElementById(date_id).style.backgroundColor='#ffffff';
document.getElementById(time_id).style.backgroundColor='#ffffff';
}
}

TIME FRAMES IN SECONDS

1 min
60 s

1 hr
3600 s

1 day
86400 s

1 week
604800 s

1 month (28,29,30,31)
2419200, 2505600, 2592000, 2678400 s

1 year (360, 365, 366)
31104000, 311040000, 31622400 s