# CAST\_TIME\_TO\_TIMESTAMP\_TZ\_UDF (TIME)

{% 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/sql-server/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 %}

## Definition

This user-defined function (UDF) casts `time` to `timestamp_tz`.

```sql
CAST_TIME_TO_TIMESTAMP_TZ_UDF(INPUT TIME)
```

## Parameters

`INPUT` TIME

The input time to be cast to `timestamp_tz`.

## Returns

Returns a `timestamp_tz` with the date as 1900-01-01 and the same time as the input.

## Usage example

Input:

```sql
SELECT PUBLIC.CAST_TIME_TO_TIMESTAMP_TZ_UDF('00:00:00.995')
```

Output:

```
1900-01-01 00:00:00.997
```
