> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# WEEK

> WEEK in Query Engine SQL.

<Note>
  This function isn't in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.
</Note>

## Syntax

WEEK( \<date\_or\_timestamp\_expr> )

Returns the week number of the year.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
> select week(FROM_UNIXTIME_WITHUNIT(1673263327000, 'milliseconds'))
2
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.