> ## 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.

# Temporal Functions

## `add_months`

*Supported Signatures*

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

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_ADD_MONTHS.html)

## `convert_timezone`

*Supported Signatures*

```sql theme={null}
function convert_timezone(varchar, varchar) returns timestamp
function convert_timezone(varchar, varchar, varchar) returns timestamp
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/CONVERT_TIMEZONE.html)

## `current_date`

*Supported Signatures*

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

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_CURRENT_DATE_function.html)

## `current_datetime`

*Supported Signatures*

```sql theme={null}
function current_datetime() returns timestamp
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `current_time`

*Supported Signatures*

```sql theme={null}
function current_time() returns time
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `date`

*Supported Signatures*

```sql theme={null}
function date($1) returns date
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `date_add`

*Supported Signatures*

```sql theme={null}
function date_add $1(varchar, bigint, $1) returns date
	where varchar in (millennium, millennia, mil, mils, century, centuries, c, cent, cents, decade, decades, dec, decs, year, years, y, yr, yrs, quarter, quarters, qtr, qtrs, month, months, mon, mons, week, weeks, w, day, days, d, hour, hours, h, hr, hrs, minute, minutes, m, min, mins, second, seconds, s, sec, secs, millisecond, milliseconds, ms, msec, msecs, msecond, mseconds, millisec, millisecs, millisecon, microsecond, microseconds, microsec, microsecs, microsecond, usecond, useconds, us, usec, usecs)
	where $1 in (date, timestamp, time, varchar)
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `date_cmp`

*Supported Signatures*

```sql theme={null}
function date_cmp(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DATE_CMP.html)

## `date_cmp_timestamp`

*Supported Signatures*

```sql theme={null}
function date_cmp_timestamp(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DATE_CMP_TIMESTAMP.html)

## `date_cmp_timestampz`

*Supported Signatures*

```sql theme={null}
function date_cmp_timestampz(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `date_part`

*Supported Signatures*

```sql theme={null}
function date_part(varchar, varchar) returns float
	where varchar in (millennium, millennia, mil, mils, century, centuries, c, cent, cents, decade, decades, dec, decs, year, years, y, yr, yrs, quarter, quarters, qtr, qtrs, month, months, mon, mons, week, weeks, w, dayofweek, dow, dw, weekday, dayofyear, doy, dy, yearday, days, days, d, hour, hours, h, hr, hrs, minute, minutes, m, min, mins, second, seconds, s, sec, secs, millisecond, milliseconds, ms, msec, msecs, msecond, mseconds, millisec, millisecs, millisecon, microsecond, microseconds, microsec, microsecs, microsecond, usecond, useconds, us, usec, usecs)
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DATE_PART_function.html)

## `date_part_year`

*Supported Signatures*

```sql theme={null}
function date_part_year(varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DATE_PART_YEAR.html)

## `dateadd`

*Supported Signatures*

```sql theme={null}
function dateadd $1(varchar, bigint, $1) returns date
	where varchar in (millennium, millennia, mil, mils, century, centuries, c, cent, cents, decade, decades, dec, decs, year, years, y, yr, yrs, quarter, quarters, qtr, qtrs, month, months, mon, mons, week, weeks, w, day, days, d, hour, hours, h, hr, hrs, minute, minutes, m, min, mins, second, seconds, s, sec, secs, millisecond, milliseconds, ms, msec, msecs, msecond, mseconds, millisec, millisecs, millisecon, microsecond, microseconds, microsec, microsecs, microsecond, usecond, useconds, us, usec, usecs)
	where $1 in (date, timestamp, time, varchar)
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DATEADD_function.html)

## `datediff`

*Supported Signatures*

```sql theme={null}
function datediff $1, $2(varchar, $1, $2) returns bigint
	where varchar in (millennium, millennia, mil, mils, century, centuries, c, cent, cents, decade, decades, dec, decs, year, years, y, yr, yrs, quarter, quarters, qtr, qtrs, month, months, mon, mons, week, weeks, w, day, days, d, hour, hours, h, hr, hrs, minute, minutes, m, min, mins, second, seconds, s, sec, secs, millisecond, milliseconds, ms, msec, msecs, msecond, mseconds, millisec, millisecs, millisecon, microsecond, microseconds, microsec, microsecs, microsecond, usecond, useconds, us, usec, usecs)
	where $1 in (date, timestamp, time with time zone, time, varchar)
	and $2 in (date, timestamp, time with time zone, time, varchar)
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_DATEDIFF_function.html)

## `getdate`

*Supported Signatures*

```sql theme={null}
function getdate() returns timestamp
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_GETDATE.html)

## `sysdate`

*Supported Signatures*

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

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_SYSDATE.html)

## `timeofday`

*Supported Signatures*

```sql theme={null}
function timeofday() returns varchar
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TIMEOFDAY_function.html)

## `timestamp_cmp`

*Supported Signatures*

```sql theme={null}
function timestamp_cmp(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TIMESTAMP_CMP.html)

## `timestamp_cmp_date`

*Supported Signatures*

```sql theme={null}
function timestamp_cmp_date(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TIMESTAMP_CMP_DATE.html)

## `timestamp_cmp_timestampz`

*Supported Signatures*

```sql theme={null}
function timestamp_cmp_timestampz(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `timestampz_cmp`

*Supported Signatures*

```sql theme={null}
function timestampz_cmp(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `timestampz_cmp_date`

*Supported Signatures*

```sql theme={null}
function timestampz_cmp_date(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `timestampz_cmp_timestamp`

*Supported Signatures*

```sql theme={null}
function timestampz_cmp_timestamp(varchar, varchar) returns bigint
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html)

## `timezone`

*Supported Signatures*

```sql theme={null}
function timezone(varchar, varchar) returns timestamp
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TIMEZONE.html)

## `to_date`

*Supported Signatures*

```sql theme={null}
function to_date(varchar, varchar) returns date
function to_date(varchar, varchar, boolean) returns date
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TO_DATE_function.html)

## `to_timestamp`

*Supported Signatures*

```sql theme={null}
function to_timestamp(varchar, varchar) returns timestamp
function to_timestamp(varchar, varchar, boolean) returns timestamp
```

[🔗 Official Documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_TO_TIMESTAMP.html)