I need help in figuring out the date conversion logic in Snowflake. The documentation isn’t clear enough on this. In SQL Server, I would try SELECT CONVERT(DATE, ‘20200730’, 101) and it gives me ’07/…
Tag: snowsql
Table Aliases into Subqueries
(Submitting here to assist other Snowflake Users who may run into similar challenges… Interested to see if there are any additional recommendations beyond what’s bee provided already.) Why doesn’t table alias work into subqueries? I was using a sample table select query but it doesn’t work when I coded a table alias. I got a SQL compilation error: Object ‘T’