CURRENTTIME

The CURRENTTIME function returns the current system time.

You can use CURRENTTIME when you need the system time as a transaction processing time, an order-received time, or a time that reflects when the data was mapped.

Syntax:
CURRENTTIME ( )
Meaning:
CURRENTTIME ( )
Returns:
A single time

The CURRENTTIME function returns the system time. If assigned to a date-time output item, the current time is returned in the format specified by that output item. Otherwise, the system time is returned in HH:MM:SS presentation.

Note: CURRENTTIME has no arguments but it does require parentheses.

Examples

  • End Time = CURRENTTIME ( )

    In this example, End Time is assigned the current time. Because CURRENTTIME is assigned to an output, it is automatically converted to the presentation of End Time.

    If CURRENTTIME evaluates to 10:15:02 and End Time has an HH12:MM presentation, the result is 1015.

  • FROMDATETIME ( CURRENTTIME ( ) , "{HH24MMSS}" )

    In this example, the current time is returned in HH24MMSS format. If the current time is 10:15:02 pm, the result is 221502.

Related functions

  • CURRENTDATETIME
  • FROMDATETIME
  • DATETOTEXT

Feedback