Data - date_trunc for PHP

Asked

Viewed 128 times

1

Postgresql has a date function called date_trunc

How can I play it in PHP?

I only need the options:

  • cond
  • minute
  • hour
  • day
  • week
  • Month
  • Quarter
  • year
php postgresql date

  • What date_trunc ago?

  • @rray I use it most of the time to get the dates aligned for a period to apply on GROUP BY

1 answer

1


Resolution

Auxiliary Functions

// REMOVE TUDO QUE NAO SEJA NUMERO, DA STRING
function onlyNumber($var){
    return preg_replace('/\D/', '', $var);
}

// AJUSTA OS NUMEROS A MASK PASSADA
function maskNumber($mask, $str){
    $str = onlyNumber($str);
    $return = '';

    for($i = 0, $j = 0; $i < strlen($mask); $i++){
        if($mask[$i] == '#' && isset($str[$j])){
            $return .= $str[$j++];
        }else{
            $return .= $mask[$i];
        }
    }

    return $return;
}

Function date_trunc

function date_trunc($field, $source){

    $source = maskNumber('####-##-## ##:##:##', $source);
    $source = str_replace('#', '0', $source);

    $date['year']   = 'Y-01-01 00:00:00';
    $date['mount']  = 'Y-m-01 00:00:00';
    $date['day']    = 'Y-m-d 00:00:00';

    $date['hour']   = 'Y-m-d H:00:00';
    $date['minute'] = 'Y-m-d H:i:00';
    $date['second'] = 'Y-m-d H:i:s';

    if(in_array($field, array_keys($date))){
        return date($date[$field], strtotime($source));
    }else{
        if($field == 'week'){
            return date($date['day'], strtotime("last Monday", strtotime($source)));
        }
        if($field == 'quarter'){
            $mount = explode('-', $source);
            $mount = $mount[1];
            $quarter = array(1=>'01',2=>'04',3=>'07',4=>'10');
            return date(sprintf('Y-%s-01 00:00:00', $quarter[ceil($mount/3)]), strtotime($source));
        }
        return date($date['day'], strtotime($source));
    }
}

Testing

date_trunc('day', '2015-10-30 14:48:15');       // 2015-10-30 00:00:00
date_trunc('week', '2015-10-30 14:48:15');      // 2015-10-26 00:00:00
date_trunc('mount', '2015-10-30 14:48:15');     // 2015-10-01 00:00:00
date_trunc('quarter', '2015-11-25 14:48:15');   // 2015-10-01 00:00:00
date_trunc('year', '2015-10-30 14:48:15');      // 2015-01-01 00:00:00

Browser other questions tagged php postgresql date

You are not signed in. Login or sign up in order to post.