# justify_days function
Adjust interval so 30-day time periods are represented as months

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


`justify_days` returns a new [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) such that 30-day time periods are
converted to months.

## Signatures



```mzsql
justify_days ( <interval> )

```

| Syntax element | Description |
| --- | --- |
| `<interval>` | An [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) value to justify. Returns a new interval such that 30-day time periods are converted to months.  |


Parameter | Type                                                                                                                                                                                            | Description
----------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------
_interval_ | [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) | The interval value to justify.


### Return value

`justify_days` returns an [`interval`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/types/interval/index.md) value.

## Example

```mzsql
SELECT justify_days(interval '35 days');
```
```nofmt
  justify_days
----------------
 1 mon 5 days
```