Convert date to integer

elgeo
Valued Contributor II

Hello. Is there a way in Databricks sql to convert a date to integer? In Db2, there is days function DAYS - IBM Documentation .

For example '2023-03-01' is converted to 738580 value.

Thank you in advance