STR2TIME Function
Function Type | Predefined function | |
Syntax | STR2TIME( <dateString>, <dateFormat> ) | |
Description | Converts a formatted date string to a Time data type value that matches the date format of the second argument. | |
Argument | Description | |
<dateString> | Formatted date string. | |
<dateFormat> | String representing the <dateString> date format. See date/time formats (explained in the Formats tab) for information on date/time format patterns. | |
Returns | Time | |
Example | This example creates a time object from the given string using the given format, in this case the time object will represent 2:30:21 p.m. STR2TIME("14:30:21", "HH:mm:ss") | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*