TIMEPART

Returns the time part from a datetime value.

TIMEPART ( <date_field or date> )

• date_field or date: The date field to use in the calculation.

Example: Create a field on the CUSTOMER table that returns just the time portion of each customer first purchase date.

TIMEPART([CUSTOMER.FIRST_PURCHASE_DATE_AND_TIME])