# Day in Week, Month, Quarter or Year Functions

Use the following functions to find the position of a day within a week, month, quarter, or year.

Date position functions take this syntax.

```nolang
SELECT EXTRACT (FUNCTIONNAME FROM DATE) AS DATEALIAS
FROM DATASET;
```

- **[Day of Week](/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-dow.md)**

  Returns an integer that represents the day of the week for a specific date.

- **[Day of Month](/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-day.md)**

  Returns an integer that represents the day of the month for a specific date.

- **[Day of Quarter](/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-doq.md)**

  Returns an integer that represents the day of the quarter for a specific date. The first quarter of the year begins on January 1.

- **[Day of Year](/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-doy.md)**

  Returns an integer that represents the day of the year for a specific date.