John Davidson

Message:

i store a date information as week into my SQL database table as a varchar. Example: 2022-W10
I want to have the quarter out of this week. Which is in my example Quarter 1 Year 2022. Is there any possibility in PHP? I have not found anything on the PHP date() documentation for this.

---

My Answer:
You can achieve this by converting the week number to a date and then extracting the quarter from that date. Here's a sample code snippet to help you with this:

php
$week = '2022-W10';

// Convert week number to date
$date = date('Y-m-d', strtotime($week . '-1'));

// Get quarter from date
$quarter = ceil(date('n', strtotime($date)) / 3);

echo 'Quarter ' . $quarter . ' Year ' . date('Y', strtotime($date));


This code snippet will output: Quarter 1 Year 2022

You can use this logic in your PHP application to get the quarter from the week number stored in your database.