ODBC_DT_TO_D()
Syntax
Date_Value as D = ODBC_DT_TO_D( Date_Time_String as C )
Argument | Description |
Date_Time_String | Date time string in the format "YYYY-MM-DD HH:MM:SS.SSS". |
Description
ODBC_DT_TO_D() converts a character Date_Time_String of format "YYYY-MM-DD HH:MM:SS.SSS" to a date value.
This function is useful when you link to an ODBC data source that has a date/time field. Since Alpha Five does not have the corresponding field type, the data is displayed as a character value. Use this function to create a calculated field that extracts just the date portion of the date-time value.
Supported By
Alpha Five Version 5 and Above
Example
odbc_dt_to_d("2003-01-15 11:46:30.003") -> {01/15/2003} |
See Also