Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference CURRENTTIME
Functions and Expressions Reference Guide
83
CURRENTTIME
The CURRENTTIME function returns the current system time.
Syntax
CURRENTTIME ( )
Note Although CURRENTTIME has no arguments, it does require parentheses.
Meaning
CURRENTTIME ( )
Returns
This function returns a single-time.
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.
Example
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.
Uses
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.
Related Functions
CURRENTDATE, CURRENTDATETIME, FROMDATETIME, DATETOTEXT