Webmaster Forum / HTML, CSS, Scripts / JavaScript / October 2007

Hi Jesmond,
I use the following functions for this task in php. This saves the user from
seeing "strange dates". Feel free to modify to suit your needs. I wrote
this code while starting out in php so it's not a slick as it could be, but
it does the job, and I havn't got around to tidying it up. (If it aint
broke.......)

regards,
Chris Roy-Smith

<?php
//this function fort making sql dates readable to non-logical date users...

function toAusDate($SQLDate){
       if ($SQLDate==null){
               return null;
       }
       $DateArray=explode("-", $SQLDate);
       if ($year=="0000"){
               return "Unknown";
       }else{
               $val = $date[2].'-'.$date[1].'-'.$date[0];
               return $val;
       }
}

// same as above, but handles time as well

function ToAusDateTime($SQLDateTime){
$year=substr($SQLDateTime,0,4);
$month=substr($SQLDateTime,5,2);
$day=substr($SQLDateTime,8,2);
$hour=substr($SQLDateTime,11,2);
$min=substr($SQLDateTime,14,2);
$sec=substr($SQLDateTime,17,2);
if ($year=="0000"){
return "Unknown";
}else{
$DateTime=$day.'-'.$month.'-'.$year.' '.$hour.':'.$min.':'.$sec;
}
return $DateTime;
}

/* makes date SQL friendly, note that it takes dates with fewer digits for
any portion of the date field, you may have to modify if you want different
asumptions as to what century a date belongs to
*/

function toSQLdate($AusDate){
// split date up, first find delimiter used.

if(strpos($AusDate,'-')){
       $delim='-';
}else if(strpos($AusDate,'/')){
       $delim='/';
}else{
       $date=false;
       return $date;
       break 2;
}
// find first break in date
$breakPos1=strpos($AusDate,$delim);
$breakPos2=strpos($AusDate,$delim,$breakPos1+1);
$day=substr($AusDate,0,$breakPos1);
if (strlen($day)==1){
       $day='0'.$day;
}
$month=substr($AusDate,$breakPos1+1,$breakPos2-$breakPos1-1);
if (strlen($month)==1){
       $month='0'.$month;
}
$year=substr($AusDate,$breakPos2+1,strlen($AusDate)-$breakPos2);
if (strlen($year)==1){
       $year='200'.$year;
}
if (strlen($year)==2){
       if ($year>40){
               $year='19'.$year;
       }else{
               $year='20'.$year;
       }
}else if(strlen($year)<>4){
$date=false;
return $date;
break 2;
}
$date=$year.'-'.$month.'-'.$day;
return $date;
}
?>

 alert('27/10/2007'.split('/').reverse().join(''))

--
Bart

Thanks Roy