- 2333 Views
- 4 replies
- 2 kudos
Azure SQL date function conversion to Databricks SQL.
I need to convert the below azure sql date_add function to databricks sql. But not getting the expected output. Can anyone suggest what can be done for this.DATE_ADD(Hour,(SELECT t1.SLA FROM SLA t1 WHERE t1.Stage_Id = 2 AND t1.RNK = 1)
- 2333 Views
- 4 replies
- 2 kudos
- 2 kudos
Hi @KVNARK .​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Thanks!
- 2 kudos
- 5461 Views
- 4 replies
- 3 kudos
Resolved! Cannot use prepared statements with date functions
We are using PHP and the Databricks SQL ODBC driver and cannot run a query that users DATE functions with prepared statements. Sample script/docker setup here:https://github.com/rlorenzo/databricks_php/blob/odbc_prepare_error/test_connection.phpFor e...
- 5461 Views
- 4 replies
- 3 kudos
- 3 kudos
@Bilal Aslam​ We tried CAST and CONVERT and still getting the same error.
- 3 kudos