TIME(a) is a function (extraction), which creates a time value from the expression a.
TIME(a)
a
Result of TIME(a) Function
a is a time value or an alphanumeric value that matches the current time format
This time value
a is an alphanumeric value that does not match the current time format
Error message
a is a time stamp value or an alphanumeric value that matches the current time stamp format
The time value that is part of the time stamp
a is a NULL value
NULL value
NULL