spark sql concatenate string and int

Hairy Guy answered on February 11, 2021 Popularity 6/10 Helpfulness 10/10

answer spark sql concatenate string and int

related spark.sql concat string

Comment

select concat('01/01/', extract(year from current_timestamp()) - 5)
select concat('01/01/', 2020)

Popularity 6/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: int sql string

Link to this answer
Share Copy Link

Contributed on Feb 11 2021

Hairy Guy

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

spark-sql> select concat(array(1,2,3),array(4), array(5,6));
[1,2,3,4,5,6]

spark-sql> select concat('Hello ', 'Kontext', '!');
Hello Kontext!

Popularity 7/10 Helpfulness 1/10 Language sql

Source: kontext.tech

Tags: concat string sql conca

Link to this answer
Share Copy Link

Contributed on Jan 10 2023

dr4ft

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.