# DAYNAME\_LONG\_UDF (TIMESTAMP\_TZ, VARCHAR)

{% hint style="info" %}
**Important Notice: Migration of Documentation Website**

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

[Official Snowflake Snowconvert Documentation](https://docs.snowflake.com/en/migrations/snowconvert-docs/general/technical-documentation/function-references/teradata/README)

For any immediate assistance or if you encounter any issues, please contact our support team at [snowconvert-support@snowflake.com](mailto:snowconvert-support@snowflake.com).

Thank you for your understanding.
{% endhint %}

{% hint style="warning" %}
This is the user-defined function (UDF) **overloaded with&#x20;**<mark style="color:orange;">**two**</mark>**&#x20;parameters.**
{% endhint %}

## Definition

Returns the complete name of a day either in uppercase, lowercase, or capitalized.

```sql
PUBLIC.DAYNAME_LONG_UDF(INPUT TIMESTAMP_TZ, RESULTCASE VARCHAR)
```

## Parameters

`INPUT` TIMESTAMP\_TZ

The date to take the dayname from.

`RESULTCASE` VARCHAR

The case that the result will present.

## Returns

Returns a varchar with the complete name of a day.

## Usage example

Input:

```sql
SELECT PUBLIC.DAYNAME_LONG_UDF(DATE '2021-10-26', 'uppercase');
SELECT PUBLIC.DAYNAME_LONG_UDF(DATE '2021-10-26', 'lowercase');
SELECT PUBLIC.DAYNAME_LONG_UDF(DATE '2021-10-26', 'firstOnly');
```

Output:

```sql
'TUESDAY'
'tuesday'
'Tuesday'
```
