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

# Date Functions

## `current_date`

*Supported Signatures*

```sql theme={null}
function current_date() returns date
function current_date(string) returns date
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#current_date)

## `date`

*Supported Signatures*

```sql theme={null}
function date(bigint, bigint, bigint) returns date
function date(timestamp) returns date
function date(timestamp, string) returns date
function date(date) returns date
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#date)

## `date_add`

*Supported Signatures*

```sql theme={null}
function date_add $1($1, interval) returns $1
	where $1 in (date, timestamp)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#date_add)

## `date_diff`

*Supported Signatures*

```sql theme={null}
function date_diff $1($1, $1, date_part string) returns bigint
	where date_part in (day, week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
	where $1 in (date, timestamp)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#date_diff)

## `date_from_unix_date`

*Supported Signatures*

```sql theme={null}
function date_from_unix_date(bigint) returns date
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#date_from_unix_date)

## `date_trunc`

*Supported Signatures*

```sql theme={null}
function date_trunc $1($1, date_part string) returns $1
	where date_part in (day, week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
	where $1 in (date, timestamp)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#date_trunc)

## `format_date`

*Supported Signatures*

```sql theme={null}
function format_date $1(string, $1) returns string
	where $1 in (date, timestamp)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#format_date)

## `last_day`

*Supported Signatures*

```sql theme={null}
function last_day $1($1) returns date
	where $1 in (date, datetime)
function last_day $1($1, date_part string) returns date
	where date_part in (week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
	where $1 in (date, datetime)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#last_day)

## `parse_date`

*Supported Signatures*

```sql theme={null}
function parse_date(string, string) returns date
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#parse_date)

## `unix_date`

*Supported Signatures*

```sql theme={null}
function unix_date(date) returns bigint
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#unix_date)