topic Re: Convert date to integer in Data Engineering

Convert date to integer

elgeo — Wed, 08 Mar 2023 11:29:15 GMT

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

-werners- — Thu, 09 Mar 2023 12:51:24 GMT

I'd cast it to a unix timestamp.

SergeRielau — Thu, 09 Mar 2023 17:19:30 GMT

TRy this:

CREATE OR REPLACE FUNCTION days(dt DATE) RETURN unix_date(dt) - unix_date(DATE'0001-01-01') + 1;

SELECT current_date, days(current_date);

2023-03-09 738588

I verified on Db2 for LUW and it matches up.