Previous Topic Next topic Print topic


TIME

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)
Previous Topic Next topic Print topic