TIME2STR Function
Function Type | Predefined function | |
Syntax | TIME2STR( <dateValue>, <dateFormat> ) | |
Description | Converts a Time data type to a formatted string that matches the date format of the second argument. | |
Argument | Description | |
<dateValue> | Time value to be converted. | |
<dateFormat> | String representing the <dateValue> date format. See date/time formats (explained in the Formats tab) for information on date/time format patterns. | |
Returns | String | |
Example | This example returns a string representing the supplied time object in the given format. In this example, if Source.Table1.TimeField was an object representing 2:02:31 a.m., this function would return "2:02" since that is the format that was requested. TIME2STR(Source.Table1.TimeField, "HH:mm") | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*