try_to_time function
Applies to: 
Databricks SQL Databricks Runtime 18.3 and above
Returns expr cast to a time using an optional formatting, or NULL if the cast fails.
Syntax
try_to_time(expr [, fmt] )
Arguments
expr: A STRING expression representing a time.- fmt: An optional format STRING expression.
Returns
A TIME.
If fmt is supplied, it must conform with Datetime patterns.
If fmt is not supplied, the function is equivalent to cast(expr AS TIME).
If fmt is malformed, Databricks raises INVALID_DATETIME_PATTERN.
If expr cannot be transformed into a time using fmt, the function returns NULL.
Common error conditions
Examples
SQL
> SELECT try_to_time('10:30:00');
10:30:00
> SELECT try_to_time('10:30:00', 'HH:mm:ss');
10:30:00
> SELECT try_to_time('not-a-time');
NULL
> SELECT try_to_time('10:30:00', 'HH:mm:ss') IS NOT NULL;
true