ToDate (PQL)
Returns a date-time column based on a string representation of a date.
- Returned Output: Date-Time
- Library: PQL \ Granular \ Date-Time
- Version: 2023.13.000
- Compatibility: Pyramid Query Language (PQL) data sources
Syntax
ToDate( <Column String> )
or
ToDate( <Text> )
* Click on the function's arguments above for more details on the input values.
Comments
- The column needs to be an attribute with string / text values in the model. (The data type needs to be 'string.')
- For details on how to employ and use this function see the custom column overview.
Different Function types
- As a granular function, this function is used in the base SQL query itself.
Examples
This example returns a column with each string value converted to a date value that can be used for subsequent date operations:
ToDate(“12/05/2024”)