Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference TEXTTOTIME
Functions and Expressions Reference Guide
205
TEXTTOTIME
The TEXTTOTIME function converts an object defined as text to an object defined
as time. The text object to be converted must be in HHMM or HHMMSS
presentation.
Syntax
TEXTTOTIME ( single-text-expression )
Meaning
TEXTTOTIME ( text_to_convert_to_time )
Returns
This function returns a single-time.
The text_to_convert_to_time must be in HHMM or HHMMSS presentation. HH
is a two-digit hour in a 24-hour format. If the result is being assigned to a time
object, the resulting time looks like the output object. Otherwise, the resulting
time looks like the input argument. If the input argument is in error (for
example, it is not a valid time), the result is NONE.
Examples
TEXTTOTIME ( CallTime ) returns CallTime as a time item.
Uses
Use
TEXTTOTIME when you want to convert an object defined as text that is in
HHMM or HHMMSS presentation, to an item defined as time. The
TODATETIME
function provides greater flexibility as to specifying the format of the text item
that is to be converted to a date/time.
Related Functions
DATETOTEXT, FROMDATETIME, NUMBERTOTEXT, TEXTTODATE,
TEXTTONUMBER, TIMETOTEXT, TODATETIME