• Article

TIMEONLY (Report Builder 1.0)

Returns the hour, minute, and second from a datetime value. The result is displayed as text.

Syntax

TIMEONLY(datetime)

datetime

Specifies the datetime from which the hour, minute, and second are extracted.

Remarks

  • To display a datetime value as a time value, you must format the field to use one of the following custom datetime format strings on the Number tab of the Format dialog box: u, f, or s.

Example

Formula

Result

TIMEONLY(#5/31/2008 12:23:56 AM#)

00:23:56