TIME: Converting to a Time

How to:

The TIME function converts its argument to a time. The type of the argument value may be character, time, or timestamp.

If the argument is a character, its value must correctly represent a time; that time is the result.
If the argument is a time, its value is returned.
If the argument is a timestamp, the time portion of the timestamp value is returned.

Syntax: How to Convert to a Time

TIME(arg)

where:

arg

character string, time, or timestamp

Is the input value.

This function returns a time.

TIME converts a value argument to a time. This example,

TIME('2004-03-15 01:02:03.444')

returns 010203444.

iWay Software