I have a dim_date_key and a dim_time_key column that I'd like to convert to timestamp and date but I cannot seem to do that with to_date or using the extract date function.
SQL TO_DATE() | Syntax and Parameters | Examples of SQL TO_DATE()
Custom DATE format for ODBC (PostgreSQL) - Toad Data Point - Toad World® Forums
PostgreSQL TO_DATE() | Learn the Working of PostgreSQL TO_DATE()
PostgreSQL Date And Time Part 2 – SQLServerCentral
How to Convert a String to a Date in PostgreSQL | LearnSQL.com
Queries for Casting - PostgreSQL | RudderStack Guides | RudderStack
Formatting and dealing with dates in SQL
SQL state: 42883 function to_date(date unknown) does not exist Postgres - Salifyanji Taala - Medium
Queries for Casting - PostgreSQL | RudderStack Guides | RudderStack