# DAY\_OF\_YEAR

| **Description** | The **`DAY_OF_YEAR`** function computes and returns the day of the year for a given date or datetime, indicating which day of the year it is. This can be valuable for time-based analytics, scheduling, or date-based calculations. |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Syntax**      | DAY\_OF\_YEAR(**`date`**)                                                                                                                                                                                                            |

1. **`date`**: The date or datetime for which you want to determine the day of the year.

## Example

### Table

| Event   | Event Date |
| ------- | ---------- |
| Event A | 2023-09-10 |
| Event B | 2023-08-25 |
| Event C | 2023-01-15 |

### Function

```
DAY_OF_YEAR(`Event Date`)
```

### Results

| DAY\_OF\_YEAR (integer) |
| ----------------------- |
| 253                     |
| 237                     |
| 15                      |
