SELECT
floor(
( UNIX_TIMESTAMP(current_date) -
UNIX_TIMESTAMP(substr(sfz,7,8),'yyyyMMdd')
)/(365*24*60*60)
) as age
from test_age;
如果hive不支持UNIX_TIMESTAMP(current_date)这种写法,就将它改成UNIX_TIMESTAMP(current_date,'yyyy-MM-dd')
SELECT
floor(
( UNIX_TIMESTAMP(current_date) -
UNIX_TIMESTAMP(substr(sfz,7,8),'yyyyMMdd')
)/(365*24*60*60)
) as age
from test_age;
如果hive不支持UNIX_TIMESTAMP(current_date)这种写法,就将它改成UNIX_TIMESTAMP(current_date,'yyyy-MM-dd')
转载于:https://www.cnblogs.com/shuaipeng520/p/11506154.html