티스토리 뷰

공부

[spark] sql MONTHS_BETWEEN(a, b) -> a - b

승가비 2023. 2. 26. 11:43
728x90
> SELECT months_between('1997-02-28 10:30:00', '1996-10-30');
 3.94959677
> SELECT months_between('1997-02-28 10:30:00', '1996-10-30', false);
 3.9495967741935485

https://docs.databricks.com/sql/language-manual/functions/months_between.html

 

months_between function | Databricks on AWS

Returns the number of months elapsed between dates or timestamps in expr1 and expr2. Returns A DOUBLE. If expr1 is later than expr2, the result is positive. If expr1 and expr2 are on the same day of the month, or both are the last day of the month, time of

docs.databricks.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[spark] spark.conf.set("spark.sql.legacy.timeParserPolicy", "LEGACY")  (0) 2023.02.26
[kotlin] semaphore & coroutine  (0) 2023.02.26
[kotlin] wait for coroutine finish  (0) 2023.02.26
[kotlin] toSortedMap (key based)  (0) 2023.02.26
[scala] loop & data = data ++ data  (0) 2023.02.23
댓글