| ANSI | DB2 | SQL/DS | XDB |
|---|---|---|---|
| X | X |
The TIME function is used to convert a value into a time. The format appears below:
TIME(expres)
The parameter expres can be a character string, a timestamp, a time, or a null value. If expres is a time, the result is the time. If expres is null, the result is the null value. If expres is a timestamp, the result is the time portion of the timestamp. If expres is a character string, it must be in one of the following formats that XDB Server recognizes:
| hh.mm.ss | ISO, EUR or JIS format |
| hh:mm: AM | PM | USA format |
For example:
UPDATE tasks SET endtime = TIME(audit_time)