TIME(a)

TIME(a) is a function (extraction) that calculates a time value from the expression 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