Ajay-Pandey
Databricks MVP

‎01-27-2023 05:04 AM

Hi @Juha Leppänen​ please refer below code-

val = '2020-04-08'
 
spark.sql("SELECT * FROM MYTABLE WHERE TIMESTAMP  BETWEEN {}  AND '2020-04-08'".format(val)).show()

Ajay Kumar Pandey