Skip to content

Instantly share code, notes, and snippets.

@jakeasmith

jakeasmith/last_quarter_timestamp.php

Last active December 20, 2018 13:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jakeasmith/5307825 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jakeasmith/5307825 to your computer and use it in GitHub Desktop.
Download ZIP
Get the timestamp for the beginning of the last quarter.
Raw
last_quarter_timestamp.php
<?php
$start_date = strtotime('3 months ago');
$start_quarter = ceil(date('m', $start_date) / 3);
$start_month = ($start_quarter * 3) - 2;
$start_year = date('Y', $start_date);
$start_timestamp = mktime(0, 0, 0, $start_month, 1, $start_year);
echo $start_timestamp;
Raw
last_quarter_timestamp.sql
SELECT UNIX_TIMESTAMP(STR_TO_DATE(CONCAT('1,', ((QUARTER(DATE_SUB(NOW(), INTERVAL 3 MONTH)) * 3) - 2), ',', YEAR(NOW())),'%d,%m,%Y'))
@adamjimenez
Copy link

adamjimenez commented Feb 25, 2016

The sql one is incorrect I think as it appends the current year. So in January it will give you October 10th 2016 instead of 2015.

@ddsc01
Copy link

ddsc01 commented Mar 13, 2018

great idea.
i needed an end date of the quarter for a range.

if anybody is in need, try this:
$end_timestamp = strtotime('last day of '.date('F', strtotime("+2 month",strtotime(date('F',$start_timestamp)."1")))." {$start_year}");

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment