SQL for Analytics Developer Guide
j
No Results
Search Tips:
- Please consider misspellings
- Try different search keywords
fiscal_quarter_last_day(date)
Accepts a DateTime, DateOnly, or legacy Date object as input. Returns an object of the same type that
corresponds to the last day of the fiscal quarter that contains the specified date.
Example
SELECT OrderDate as "date", fiscal_quarter_last_day(OrderDate) as "fiscal_quarter_last_day" FROM "dates_sample_data";| date | fiscal_quarter_last_day |
|---|---|
| 2015-01-21 15:30:00 | 2015-01-31 00:00:00 |
| 2015-01-21 00:00:00 | 2015-01-31 00:00:00 |
| 2015-01-31 10:00:30 | 2015-01-31 00:00:00 |
| 2015-02-03 15:30:00 | 2015-04-30 00:00:00 |
| 2016-01-21 23:59:59 | 2016-01-31 00:00:00 |
| 2015-10-31 23:59:59 | 2015-10-31 00:00:00 |
| 2015-12-03 00:00:00 | 2015-01-31 00:00:00 |
| 2016-01-11 03:30:00 | 2016-01-31 00:00:00 |
| 2016-01-11 03:30:00 | 2016-01-31 00:00:00 |